Page 4 of 23PREVNEXT

Queries II: Limit your data and calculate values

Criteria focus your query.

Criteria help limit the results of a query by specifying precisely what you want — in this case, only lunch recipes.

Although you can use queries to extract data from a few fields in a large table — for example, you could retrieve just the name and title from a large employees table that contains 30 fields — using criteria limits your results even further.

For example, you could retrieve the employees who report to a specific manager or who were hired after a certain date.

In Design view, you enter criteria in a Criteria cell to specify a condition that you want the data to meet. This condition is sometimes known as a simple value — simple text, numbers, or dates — or as an expression — values and functions in combination with comparisons and calculations (more about expressions later).

Page 4 of 23PREVNEXT