Create a formula in Access

In Microsoft Office Access 2007, a formula is also known as an expression. An expression consists of a number of possible elements that you can use, alone or in combination, to produce a result, including:

  • Identifiers (the names of fields, controls, or properties)
  • Operators, such as + (plus) or - (minus)
  • Functions
  • Constants
  • Values

You can use an expression (a formula) to:

  • Perform a calculation.
  • Retrieve the value in a field or control.
  • Supply criteria to a query.
  • Define data validation rules.
  • Create calculated controls and calculated fields.
  • Define group levels for reports.

Find links to more information about expressions in the See Also section.

 Tip    Try Office 2010 New features such as AutoText and Quick Info have been added to the Expression Builder in Access 2010, making it easier than ever to create expressions. Read an article or try Office 2010!

 
 
Applies to:
Access 2007