Specifying Criteria
Selecting a criteria-based subset of your data is useful for decision support. You can specify certain criteria to be met for a record to be placed in the query result. When you specify criteria for a query, you use an expression. The expression tells MS Access which records to include in the query’s dynaset.
To specify criteria as either a simple word, like “Power ” or as a complex definition, “Between 100 And 500,” you can type the expression in the Criteria cell in the field’s row on the grid . To find a customer named “Power” could type any of these in the Criteria cell: Power, =Power, “Power” , or =“Power”. After you have entered your criteria and moved to another cell, MS Access checks and displays the criteria in a standard format which is “Power”.