Microsoft Access - Simplify Building Query Criteria And Field Expressions (Access 97/2000/2002/2003)


You've probably used the Expression Builder to construct property setting values. If a property supports one of Access's builders, placing your insertion point in the property's text box displays the Build button (which resembles an ellipsis). You can also use the Expression Builder to help set up queries, even though no Build button appears when you work in a Field or Criteria text box. To access the builder, simply right-click on the Field or Criteria text box and choose Build from the shortcut menu.

Go back