Microsoft Office Tutorials and References
In Depth Information
Fine-tuning Criteria with AND and OR
8. Enter either one of the following:
•Theheadername,inquotationmarks,ofthedatabasefieldthat
the function should process
•Thecolumnnumber
9. Enter a comma ( ,).
10. Enter the range of the criteria area.
11. Type a ), and press Enter.
Fine-tuning Criteria with AND and OR
Excel’s database functions would not be of much use if you could not create
fairly sophisticated queries. A few common types of queries follow:
Records that match two or more individual criteria
Records that match any one of several criteria
Values that fall within a specified range
To find records that match two or more criteria, place the criteria in adjacent
columns in the criteria area. Continuing with the student grade database, the
criteria area shown in Figure 17-4 matches records where the Class field
contains Accounting 101 and the Teacher field contains Mr. Harris. This is
called an AND criterion.
Figure 17-4:
Finding
records that
match two
criteria.
To match records that meet any one of several criteria, place the individual
criteria in two or more rows below the field name. Figure 17-5 shows a
criteria range that matches all records where the Class field contains either
Accounting 101 or English Literature. This is called an OR criterion.
Search JabSto ::




Custom Search