2011

To construct a query with a single parameter on the Query Builder tab
1 Open the Query Editor as described in To open the Query Editor.
2 On the Query Builder tab, select a field from the drop-down list in the
Field cell.
3 Select an operator from the Operator cell drop-down list.
4 Enter a value in the Value cell, or click the [...] button.
The [...] button returns a list of all values for the specified field from the
database table, allowing you to select the value you want. After selecting
a value, click OK.
5 If you want to save the query in the current drawing for future use, click
Store.
6 Click Execute to execute the query and close the dialog box.
To construct a query with multiple parameters on the Query Builder tab
1 Enter the first parameter of your query as described in To construct a
query with a single parameter on the Query Builder tab.
2 Select the appropriate And or Or operator from the Logical field.
Clicking in the Logical field inserts an And operator. Clicking the cell
again changes the value to Or.
3 Enter additional query parameters on subsequent rows of the Query grid.
1904 | Chapter 39 Access External Databases