Using Expressions in Queries

You can use an expression anywhere in a query that you can use a column name. Expressions can calculate values to display, be part of search conditions, or combine the contents of data columns. An expression can consist of a mathematical calculation or a string, and can involve any combination of column names, literals, operators, or functions.

Examples of the use of expressions in a query include:

For more information about creating and using expressions, refer to the topics listed in the following table.

For information about See
How to create expressions Creating an Expression
How to enter expressions into a query Using Expressions in a Query
Creating summaries of data Summarizing and Grouping
Operators you can use in expressions Operators for Expressions
Functions you can use in expressions Functions for Expressions
Predefined variables you can use in expressions Predefined Variables for Expressions