Demo: Use the Expression Builder

Using the Expression Builder

( 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):

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.

Applies To: Access 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language