access+database+training - Cross tab query?

Hi Andrew,

Thank you for the question, so for the delay in getting back to you.

To create a basic cross tab query fo you are in the Database window, click Queries under Objects, and then click New on the Database toolbar.

In the New Query dialog box, click Crosstab Query Wizard, and then click "OK".
Follow the directions in the wizard dialog boxes. In the last dialog box, you can choose to run the query or see the query's structure in Design view.

If the resulting query isn't exactly what you want, you can rerun the wizard or change the query in Design view.

Hope that helps

Tracy