Examples of expressions that calculate on or manipulate values by using a calculated field in a query

Enter the expression for the calculated field in the Field cell in the query design grid.

What do you want to do?

Learn how to create an expression

Learn more about calculated fields

See examples of expressions that manipulate text

See examples of expressions that perform arithmetic operations

See examples of expressions that manipulate and calculate dates

See examples of expressions that count, sum, and average values using SQL aggregate or domain aggregate functions

See examples of expressions for working with blank fields (Null values)

See an example of an expression that uses a subquery