DBWebApplications 





Finding, Filtering, Sorting  «Prev 

Filter records using Multiple Criteria

There are three logical operators that you are likely to need as you create criteria to filter your data: And, Or, and Not. In most cases, you do not have to type the operator, since Access combines the criteria with an operator depending on where you put them. For instance, when you use Filter by Form there is a separate tab for criteria that you want to be preceded by Or, whereas criteria you put on one tab are automatically joined by And.
So what exactly do these operators do? Well, Not is easy--it tells Access what you do not want to see. And and Or can get a little confusing. Here is how to think of them: And tells Access that a record must meet both criteria in order to be displayed. For instance, you want to see clients with Casa Grande And Arizona in their records. Or, on the other hand, is a looser requirement, it tells Access that you want to see records with either of your criteria. A request for Austin Or Arizona would produce more records: clients in Austin as well as those in Arizona.
Clear? You will get more practice when you create queries.