Expression

Description

[ShippedDate] - [RequiredDate] > 3

Displays records where the shipped date is more than three days later than the required date.

([UnitPrice] * [Quantity]) + [Freight] <= 1000

Displays records where the order cost including freight is less than or equal to 1000.

[RegionSales] / [TotalSales] > .05

Displays records where the region sales are more than 5 percent of the total sales.

 

When you use an arithmetic operator (+, -, *, /) in an expression, and the value of one of the controls in the expression is Null, the result of the entire expression will be Null. You can convert the Null value to zero (or any value) by using the IfNull function.

 

For example: ([UnitPrice] * IfNull([Quantity], 0) ) + [Freight] <= 1000