Free E-Books

You can also right-click Paste to revert to the
previous content (in this case, a blank cell).
Entering other simple criteria
You can also specify criteria for Numeric, Date, and Yes/No fields. Simply enter the example
data in the criteria field.
It is also possible to add more than one criteria to a query. For example, suppose that you want to
look only at contacts who are both sellers and buyers (???BOTH??? type in the ContactType field),
and those contacts have been customers since January 1, 2007 (where OrigCustDate is greater
or equal to January 1, 2007). This query requires criteria in both the ContactType and
OrigCustDate fields. To do this, it is critical that you place both examples on the same Criteria
row. Follow these steps to create this query:
1. Create a new query starting with tblContacts.
2. Add ContactType, FirstName, LastName, State, and OrigCustDate to the
QBE grid.
3. Enter BOTH in the Criteria cell in the ContactType column.
4. Enter >= 01/01/07 in the Criteria cell in the OrigCustDate column.


Pages:
424 425 426 427 428 429 430 431 432 433 434 435 436 437 438 439 440 441 442 443 444 445 446 447 448