Like this article? We recommend
Like this article? We recommend
Like this article? We recommend
Numeric Criteria
For numeric criteria, you can define an exact match by simply entering the desired value in the criterion cell. For ranges of values, you can use the operators less than (<), greater than (>), less than or equal to (<=), and greater than or equal to (>=). For instance, the criterion shown in Figure 5 matches all records in which the value in the PubYear field is 1960 or greater.
)
Figure 5 Defining a criterion that is a numeric range
If you want to define a numeric criterion that has both an upper and a lower limit, place the upper and lower criteria in adjacent columns, as shown in Figure 6. This criteria range will select those records in which the PubYear value is between 1960 and 1998, inclusive.
)
Figure 6 Defining a criterion that is a numeric range between two values
Because Excel treats dates as numbers, criteria work the same way. If your database contains a field named PurchaseDate that contains date values, the criterion shown in Figure 7 matches all records in which that field contains a date before January 1, 2004.
)
Figure 7 Criteria for date data work the same as numeric criteria.