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    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.

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Support resources

Change language