Please enable JavaScript to view this site.

thankQ Help

An expression is a string that, after parsing and processing, returns a value. Expressions consist of column/field names, operators, functions, and constants. See the following examples of expressions:

•"[Quantity] * [UnitPrice] * (1 - [BonusAmount])"

•"[FirstName] + ' ' + [LastName]"

•"[Country] == 'USA'"

•"[OrderDate] > #8/16/1994# AND [Quantity] > 20"

Note

 

Expressions for unbound columns/fields can evaluate values of any type. Expressions that represent criteria for conditional formatting rules have to evaluate boolean values.

You can use the Expression Editor to create or edit expressions.