Microsoft Office Tutorials and References
In Depth Information
Using Dates or Numbers as Criteria
You can use OR to join criteria from different fields. The criteria range in
Figure 12.55 shows a Region value of West joined by an OR with a District
value of Texas. This pulls a superset of all the West records plus just the
Texas records, which happen to fall in the Central region.
Figure 12.55.
Figure 12.55. The criteria to be joined with
The criteria to be joined with OOR can be in separate columns.
can be in separate columns.
Using Dates or Numbers as Criteria
The example in Figure 12.56 finds records with a date after 2017 and with rev-
enue under $50,000. The criteria in F18 for the date could have used any of
these formats:
>12/31/2017
>=1/1/2018
>31-Dec-2017
Figure 12.56.
Figure 12.56. Using dates or numbers in criteria.
Using dates or numbers in criteria.
Search JabSto ::




Custom Search