Microsoft Office Online
Sign in to My Office Online (What's this?) | Sign in

 
 
Microsoft Office Access
Search
Search
 
Check for updates: (c) Microsoft
Office downloads
 
 
 
Warning: You are viewing this page with an unsupported Web browser. This Web site works best with Microsoft Internet Explorer 6.0 or later, Firefox 1.5, or Netscape Navigator 8.0 or later. Learn more about supported browsers.

Email this linkEmail this link Printer-Friendly VersionPrinter-Friendly Version Bookmark and ShareShare
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.

For more information about expressions

advertisement