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):
Tip New features such as AutoText and Quick Info have been added to the Expression Builder in Access 2010, making it easier than ever to create expressions.