Filemaker Pro 10 TU693LL/A Benutzerhandbuch

20     FileMaker Pro Tutorial

3. In the layout bar, click Operators and choose range from the list.

Alternatively, you can type any operator from the menu directly into a search field.

Your find request should now have 1/1/2009... in the Date Paid field. 

4. Immediately after the ellipsis (...), type 6/30/2009.

5. Click Perform Find or press Enter or Return.

Your search returns six records, for six members who paid their fees within the first six months of the 
year 2009.

Sometimes, you might need to find records that match certain criteria while at the same time excluding 
others (for example, finding all of the records that were added in a given year except for those added in a 
particular month, or finding all customers who reside in the United States, except for those in New York 
City). You can perform these types of finds by using a combination of multiple find requests and omitting 
certain records.

Because FileMaker Pro processes multiple find requests in the order they are created, it is possible to create 
very specific, layered searches in this manner. Omitting records in a search does not delete them from the 
database.

To find the records of members who paid their fees in 2009, except for the members who paid their fees in 
March:

1. Click Find.
2. Type 2009 in the Date Paid field.
3. Click New Request. Notice that the status toolbar shows that this is the second find request in this 

database search.

Choose range