Free E-Books

In this example, you looked for all vehicles that didn??™t contain cars in the category
field. To find records that match a value, drop the use of the <> operator with the value.
For example, enter the expression Cars to find all vehicles that have a category of cars. You don??™t
have to use the equal (=) operator in the QBE pane when looking for matching values.
The And/Or operators are the most commonly used operators when working with complex criteria.
The operators consider two different formulas (one on each side of the And/Or operators) and
then determine individually whether they are True or False. Then the operators compare the
results of the two formulas against each other for a logical True/False answer. For example, take
the first And statement in the formula given in the preceding paragraph:
(tblContacts.State = ???CT??? AND tblProducts.Category <> ???Cars???)
The first half of the formula, tblContacts.State = ???CT???, converts to a True if the state is CT
(False if a different state; Null if no state was entered in the field).


Pages:
488 489 490 491 492 493 494 495 496 497 498 499 500 501 502 503 504 505 506 507 508 509 510 511 512