Calculated 1

Mathematical operations are used such as >,<, or,=.

It will display records from 11-19 bu not 10-20

Works the same way as numbers.

It is an expression that you type into the criteria cell of the query or filter grid.

Is a special character that is used to substitute unknown characters in a query.

It is a new field query that displays the results of a calculations using the expression.

It is a wild card that represents string of text or two more characters.

It is a combination of symbols, identifiers, operators and values.

Below are commonly used criteria except.

It is a wildcard that represents single character.