Microsoft Office Tutorials and References
In Depth Information
Query to find positions in PE that start on 07/01/2006
And logical operator;
conditions entered in
the same row
Notice that Access added quotation marks around the entry “PE”; you can type the quota-
tion marks when you enter the condition, but if you forget to do so, Access will add them
for you automatically.
The condition for the StartDate field is already entered, so you can run the query.
3. Run the query. Access displays in the datasheet only those records that meet both condi-
tions: a StartDate field value of 07/01/2006 and a StateProv field value of PE. Two records
are selected. See Figure 3-28.
Results of query using the And logical operator
Now you can save the changes to the query and rename it.
4. Save and close the query. You return to the Database window.
5. Right-click July1Positions in the Queries list box, and then click Rename on the shortcut menu.
6. Press the Home key to position the insertion point to the left of the text “July,” type PE ,
and then press the Enter key. The query name is now PEJuly1Positions.
Now Elsa can run the PEJuly1Positions query whenever she needs to know which
employers in Prince Edward Island are offering positions starting on 07/01/2006.
Using Multiple Undo and Redo
Access allows you to undo and redo multiple actions when you are working in Design
view for tables, queries, forms, reports, and so on. For example, when working in the
Query window in Design view, if you specify multiple selection criteria for a query, you
can use the multiple undo feature to remove the criteria—even after you run and save
To see how this feature works, you will reopen the PEJuly1Positions query in Design
view, delete the two criteria, and then reinsert them using multiple undo.