Expressions combine identifiers, operators, functions and values into a unit that produces a result. Expressions can be as simple as an arithmetic expression, such as (1+1), that produces a numeric result, 2. Or they can perform complex operations on data, such as the following validation expression which generates an error if the value of the Country field is France, Italy, or Spain and the Post Code field contains fewer than or more than five characters:
Country In ("France", "Italy", "Spain") And Length(PostCode)<>5
The following are simple examples of expressions that you can adapt for use in your own queries. To build more complex queries, put the screen in query mode , type ':' into any field and execute the query as normal. This will bring up a Query/Where box into which you can type your expression. To find the name of a field, click in the field and select Help > Name of current field.
Examples