Creating a formula in Access

Woman with pencil and calculator: (c) Corbis

Applies to
Microsoft Office Access 2003
Microsoft Access 2000 and 2002

In Access, the term expression is synonymous with formula. An expression consists of a number of possible elements that are used alone or in combination to produce a result. The possible elements include the following:

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

You use an expression to perform a calculation, retrieve the value of a control, supply criteria to a query, define rules, create calculated controls and calculated fields, and define a group level for a report.

 Tip    Try Office 2010 In Access 2010, the Expression Builder has IntelliSense, so you can see what arguments your expression requires.
Watch a video or try Office 2010.

For more information about expressions

Applies to:
Access 2003