Microsoft Office Tutorials and References
In Depth Information
Filtering by single and multiple combinations of choices
Filtering by single and multiple combinations of choices
Each row in the query grid allows you to specify a
combination of choices, which when taken together will limit the data
displayed. Each line on the query grid allows you to specify a
separate set of choices. This means that a query can apply very
sophisticated sets of criteria to limit the data returned.
Choosing to restrict the data displayed in each column bases the
matching on ranges of values, sets of values, and patterns in the
data.
Filter to match similar text
1 In the criteria for a text field, type *al* . Access changes this to Like
“*al*”, which will display any record containing the letters al as part
of the data in this column.
1
TIP Access uses the keyword like when matching part of the
text in text fields. You do not need to type this because Access
does it for you. Also note that searching is not case-sensitive.
1
Add a second set of criteria
1 In the query grid, in the Or row, add further criteria by typing ba* .
This displays all records where either the company name starts with
the letters ba or the contact name includs the letters al .
TIP If you add multiple criteria in each row, all the criteria in
the row will apply. This means that we have an AND between
the criteria; and between two rows, we have (row 1 criteria) OR (row 2
criteria).
Search JabSto ::




Custom Search