Pro-Form Quick Start 9.0 User's Guide download pdf (Page 21)

Lesson 3 | Finding and sorting records 21

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

5. Click Perform Find.

Your search returns six records, for six customers who paid their fees within the first six months

of the year 2011.

Narrow your search

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 customers who paid their fees in 2011, except for the customers who paid

their fees in March:

1. Click Find.

2. Type 2011 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.

4. Click Omit in the layout bar to have FileMaker Pro exclude any records in the found set that fit

the criteria of this second find request.

5. Type 3/1/2011 in the Date Paid field.

6. Click Operators, then select range from the list.

7. After the ellipsis, type 3/31/2011 in the Date Paid field to exclude customers who paid at any

time during the month of March.

8. Click Perform Find.

Your search returns 11 records for 11 customers who paid their fees in 2011, except the

customers who paid during the month of March.

Click Omit

1 2 ... 16 17 18 19 20 21 22 23 24 25 26 ... 81 82

No comments

Pro-Form Quick Start 9.0 User's Guide Page 21