Create an expression using the Expression Builder

1. Start the Expression Builder.

   How?

2. In the lower-left box of the Expression Builder, double-click or click the folder containing the element you want.
   
   
3. In the lower-middle folder, double-click an element to paste it into the expression box, or click a category of elements.
   
   
4. If you select a category in the lower-middle box, values display in the lower-right box. Double-click a value to paste it in the expression box.

   Tip   You can also type any part of the expression directly in the expression box.

5. Paste any operators you want in the expression by placing the insertion point in the expression box where you want the operator, and clicking one of the operator buttons that are in the middle of the builder.
   
   
6. When your expression is complete, click OK.

Microsoft Access copies your expression to the location where you started the Expression Builder. If that location already contains a value, your new expression replaces the value or text.

For more information about the Expression Builder, click .