Microsoft Office Tutorials and References
In Depth Information
3. With the StartDate field condition highlighted, press the Delete key. Now there is no con-
dition for the StartDate field.
4. Click the Run button on the Query Design toolbar. Access runs the query and displays
the selected fields for only those records with a Wage field value greater than or equal to
17.00. A total of 19 records are selected. See Figure 3-25.
Running the modified query
only records with a Wage value greater than or
equal to 17.00 are selected
So that Matt can display this information again, as necessary, you’ll save the query as
5. Click File on the menu bar, and then click Save As to open the Save As dialog box.
6. In the text box for the new query name, type HighWageAmounts . Notice that the As text
box specifies that you are saving the data as a query.
7. Click the OK button to save the query using the new name. The new query name appears
in the title bar.
8. Close the Query window and return to the Database window.
Elsa asks Matt for a list of the positions with a start date of 07/01/2006 for only the employ-
ers in Prince Edward Island. She wants to increase NSJI’s business activity throughout eastern
Canada (Prince Edward Island in particular), especially in the latter half of the year. To pro-
duce this data, you need to create a query containing two conditions—one for the position’s
start date and another to specify only the employers in Prince Edward Island (PE).
Defining Multiple Selection Criteria for Queries
Multiple conditions require you to use logical operators to combine two or more condi-
tions. When you want a record selected only if two or more conditions are met, you need to
use the And logical operator . In this case, Elsa wants to see only those records with a
StartDate field value of 07/01/2006 and a StateProv field value of PE. If you place conditions
in separate fields in the same Criteria row of the design grid, all conditions in that row must