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.

Was this information helpful?

Great! Any other feedback?

How can we improve it?

Thank you for your feedback!

×