User manual

Finding records | 53
2. Click Find and type the criteria to broaden the search (type Hong Kong in
the City field).
3. Choose Requests menu > Extend Found Set.
The found set now consists of customers in New York and Hong Kong.
Note To quickly extend the found set in Browse mode, use the shortcut menu.
Click in the field (or select a partial value in the field), then right-click (Windows)
or Control-click (Mac
OS), and choose Extend Found Set.
Records that match one set of criteria but not another
To narrow your search by excluding records that meet specified criteria (for
example, to find vendors in New York state that are not in New York City), see
“Finding some records while omitting others” on page 54.
Finding records except those matching criteria
You can exclude (omit) records while performing a find. In other words, you
can find information in your database that “does not equal” your specified
criteria. For example, you can find all invoices except those created in the past
30 days.
Finding records that don’t match criteria
For example, to find all sales records except those for the city of London:
1. In Find mode, type criteria for the records to omit.
2. Click Omit in the layout bar.
3. Click Perform Find.
Click Omit to exclude
records that match
the request
φμπ10_υσερσ_γυιδε.βοοκ Παγε 53 Μονδαψ, Αυγυστ 25, 2008 3:59 ΠΜ