Free E-Books

If you only add the tblContacts table, you will see both sellers and buyers. When you
add both tables, the query only displays buyers because tblContacts.ContactID is
linked to tblSales.Buyer; the query only shows contacts who appear as a buyer in tblSales??”
thus eliminating the sellers.
2. Add LastName, FirstName, and State from tblContacts.
3. Click in the Criteria: cell of State.
4. Type Not NY in the cell.
Access automatically places quotation marks around NY if you don??™t do so before you
leave the field. You can also use <> instead of the word Not as in Figure 5-7. The query
should look similar to the one shown in Figure 5-7. The query selects all records except
those for buyers who live in the State of New York.
You can use the <> operator instead of Not in Step 4 of the previous instructions to
exclude New York (NY). The result is the same with either operator. These two operators
are interchangeable except with the use of the keyword Is. You cannot say Is <> Null. Rather, you
must say Not Is Null or more accurately Is Not Null.


Pages:
502 503 504 505 506 507 508 509 510 511 512 513 514 515 516 517 518 519 520 521 522 523 524 525 526