Share this Page URL

Chapter 9. Extending Your Use of Queries > Running Action Queries - Pg. 320

Extending Your Use of Queries 5. 6. 320 Click OrderID at the top of the list of fields, hold down the Shift key, and then click Ship-Country at the bottom of the list. Drag the list of fields to the query design grid. In the Criteria row for the OrderDate field, enter the expression <#1/1/97#. The query design grid should now look like the following: