MS Access™ MVP Awardee: 2007-2017
Blog: GPG on Access
Published Books:
Professional Access 2013 Programming with co-authors Teresa Hennig, Ben Clothier and Doug Yudovich. Grover Park George On Access MS Access™ in a SharePoint World with co-authors Tim Runcie and Ben Clothier.
The Expression Builder in Access can help you create expressions in queries, calculated controls on forms and reports, and in Event Procedures, such as the After Update event of a list or combo box. To use the Expression Euilder in a query, for example, open the query to the Query Grid in design view and click the Builder Button on the Toolbar. (It has three dots on it "…", along with the Wizard Wand. ) The Expression Builder opens, giving you access to all of the objects in the database along with built-in Functions and and functions you've created yourself. Doubl-click on elements in the lower-middle or lower-right sections of the builder to add them to your expressions. When you click "OK" the expression is copied back to your query. The Expression Builder also provides context sensistive help and templates for functions to guide you as you create your expressions.