Examples of criteria expressions for queries or advanced filters

You can use a criteria expression in the Criteria cell, either in the Advanced Filter/Sort window or in query Design view.

Note   You can also use custom criteria expressions in a field in the Filter By Form window, or use the expressions from the list in the fields.

What do you want to do?

See examples of expressions that use text values as criteria

See examples of expressions that calculate or manipulate dates, and then use the result as criteria

See examples of expressions that use a blank field's value (Null or zero-length string) as criteria

See examples of expressions that use part of a field's value as criteria

See examples of expressions that use the result of a domain aggregate function as criteria

See examples of expressions that use the result of subqueries as criteria

See examples of using multiple criteria in one or more fields in a query