• Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint
Share this Page URL
Help

Chapter 34. Using Queries > Adding Criteria to a Query

Adding Criteria to a Query

As you design a query, you can add criteria to make the query more specific.

To add criteria:

1.
On the Queries tab of the Database window, select a query and click the Design button.

or

Click the Design view button if the query is open.

2.
In the Criteria cell for a field in the query design grid, enter the number or text to match.

or

Enter an expression to match a range of values.

3.
For help in constructing an expression, right-click in the Criteria cell for a field and choose Build from the shortcut menu.

or

Click in the Criteria cell for a field and click the Build button on the Access toolbar (Figure 34.16).

Figure 34.16. Click the Build button on the Access toolbar.


4.
In the Expression Builder dialog box, you can type in the box at the top, click buttons to add the common operators, and click the Paste button to add items from the submenus in the bottom section (Figure 34.17).

Figure 34.17. Build the expression in the Expression Builder dialog box.


5.
Click OK when you have finished building the expression.

6.
Click the Run button to view the results.

7.
Click the Design view button to return to designing the query (Figure 34.18).

Figure 34.18. The query in Design view.


8.
Save the query design.


PREVIEW

                                                                          

Not a subscriber?

Start A Free Trial


  
  • Creative Edge
  • Create BookmarkCreate Bookmark
  • Create Note or TagCreate Note or Tag
  • PrintPrint