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