Query Save

1. From the Tools menu, select the Queries... option.

   The Queries form is displayed.
   

2. Select the module and record area, and either create a new query, or modify an existing query.

   Information on creating or modifying a query is available in Create New Query and Modify Query.

3. Verify that Report is selected for Query Type(s) for the query.

4. Click the Pivot Table tab.

   The fields listed in Available Cross-Tab Fields are the selected fields from the Fields section.

   • Properties

   • Tables

   • Fields

   • Join

   • Filter

   • Order By

   • Group By

   • Having

   • Pivot Table

5. Press Save to save the query.
6. Close the Query Designer form, or continue to modify the query.