Demo: Use the Expression Builder
( Download the demo.)
(You may experience a delay while the demo is loading.)
You can use expressions throughout Access—for example, to calculate values, act as query criteria, or validate data. The Expression Builder helps you create expressions by providing easy access to the names of the fields and controls in your database, and to many of the built-in functions that are available to you when you write expressions. This demo shows you how to use the Expression Builder for one common task—calculating a date value on a report.
How to do it (text version):