Free E-Books

5. Run the query.
Figure 4-19 shows how the query should look.
Access displays records of contacts that are both sellers and buyers that became customers after
January 1, 2007??”in this example, two contact records.
Multi-criteria queries are covered in depth in Chapter 18. CROSS-REF CROSS-REF
143
Selecting Data with Queries 4
FIGURE 4-19
Specifying character and date criteria in the same query
Access uses comparison operators to compare Date fields to a value. These operators include less
than (<), greater than (>), equal to (=), or a combination of these operators. Notice that Access
automatically adds pound sign (#) delimiters around the date value. Access uses these delimiters to
distinguish between date and text data. The pound signs are just like the quote marks Access
added to the ???Cars??? criteria. Because the OrigCustDate is a DateTime field, Access understands
what you want and inserts the proper delimiters for you.
Operators and precedence are covered more in Chapter 5.


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