|
::
Introduction
::
Database principles
::
Tables
::
Queries
::
Data security
::
Glossary
::
Resources
::
Student Files
:: Contact
:: Back to Main Site
:: Site
Map
|
Microsoft Access - Class 3 - Part XII
|
>
Back |
Using Multiple Criterias
There are two ways that multiple criteria may be used :
| 1. |
Logical AND includes the record in the
dynaset only if all the criteria are true. Logical AND is exclusive.
For each new criterion you add, there will be fewer records
that match all the criteria. |
|
|
|
|
2.
|
Logical OR includes the record if any one
of the criteria is true. Logical OR is inclusive. For each new
criterion you add, there will be more records that match at
least one criterion. |
You can combine logical AND with logical OR by entering several
rows of criteria, each with criteria entered under several fields.
You can create most queries you want by entering criteria in the
Design grid. However, there are cases where it is easier or more
powerful to use logical operators.
Print this page
|
