True when it is compared to a number that is greater than 0.įalse when it is compared to a number that is less than 0. For example, this Boolean expression consists of just an operator and a constant: >0 This expression can be used in a text box in a form footer or report footer to calculate sales tax for a group of items.Įxpressions can be much more complex or much simpler than this example. The nesting limit for expressions in a web database is 65Īn expression is a combination of some or all of the following: built-in or user-defined functions, identifiers, operators, values, and constants that evaluate to a single value.įor example, the following expression contains common components: =Sum()*0.08 In this articleįunctions, operators, constants, and values But with a good understanding of expression syntax and a little practice, it becomes much easier. Initially, expressions in Access are a little bit hard to read. Syntax is the set of rules by which the words and symbols in an expression are correctly combined. To use expressions, you write them by using proper syntax. You can calculate these values by using expressions.

For example, you want to calculate sales tax on an order, or calculate the total value of the order itself. When you use Microsoft Access, you often need to work with values that are not directly in your data.

Microsoft access 2013 tutorial 7 case 1