Demo: Use the Expression Builder

Using the Expression Builder Play Demo Demo button

(Or Down arrow 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):


Assistance Problems watching the video? Try our troubleshooting tips.

 Tip    Try Office 2010 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. Read an article or try Office 2010!

 
 
Applies to:
Access 2007