• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 5. Creating Data Reports > Using Search Operators

Using Search Operators

FileMaker uses search operators to extend the power of Finds. “And” and “Or” searches are “big gun” tools that allow you to pull out large categories of data based on field names. Search operators are more like precision instruments: Using them, you can search for information that's more deeply buried in the database records themselves. These search operators are also very useful if you're not exactly sure what you're looking for but you know it has to be there. Mistyped entries, variant spellings, a checkbook discrepancy in the February balance—they can all be located with a well-chosen search operator.

The range operator is most often used to find a series of dates or numbers, but it's equally useful for an alphabetic search. In fact, most operators allow you to use letters in the same manner as numbers in finds. Try this with the range, greater than and less than operators to search for items in different parts of the alphabet.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint