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

Chapter 5. Finding and Sorting Records > Doing Multiple Criteria Searches

Doing Multiple Criteria Searches

What distinguishes a multiple criteria search from a simple search is that you're looking for several values within the same field. To go back to our real estate example, you may want to find homes on Pomona Avenue and San Carlos Avenue. Both items would appear in the Street Name field, so you'll need to make a multiple criteria search.

To do a multiple criteria search:

1.
Choose View > Find Mode or use your keyboard: (Windows) or (Mac). Type what you're seeking into the relevant field. Do not hit or just yet.

2.
To add your second search item, choose Requests > Add New Request (Figure 5.8). Or use your keyboard: (Windows) or (Mac). A duplicate set of blank fields will appear (Figure 5.9).

Figure 5.8. To add another request to your search, choose Requests > Add New Request.


Figure 5.9. In a multiple criteria search, a second set of fields will appear—allowing you to look for several values within the same field.


3.
Type what you're seeking into the duplicate of the field you used in the first request. Within the left-hand mode status area, the number of requests you've made within this set of records is displayed. If you want, you can continue to add multiple criteria by repeating this step.

4.
When you're ready, click the Find button in the mode status area or press (Windows) or (Mac). The search will display all records that match any of your criteria requests (Figure 5.10).

Figure 5.10. In this multiple criteria search example, the streets San Carlos and Pomona appear. Such searches can handle any number of requests for data in the same field.



PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


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