UtterAccess HomeUtterAccess Wiki

Welcome Guest ( Log In | Register )

Custom Search
Edit Discussion
> Expression    
Expression

Expression

Definition: A series of functions, calculations, or values that, when passed to the Jet Expression Service, returns a single result.

The term "expression" most often refers to the formula for calculating a value in a control in either a form or report. In this context, it is always preceded by an equals sign (=). It can also refer to a calculated field within a query.

Control Examples:

=[Quantity]*[Price]

=[Amount]*.25

=[LastName] & ", " [FirstName]

Query Examples:

NetAmount: [Quantity]*[Price]

TwentyFivePercent: [Amount]*.25

FullName: [LastName] & ", " [FirstName]

Edit Discussion
Custom Search
Thank you for your support!
This page has been accessed 3,639 times.  This page was last modified 01:43, 21 July 2012 by Walter Niesz.   Disclaimers