Forum home » Delegate support and help forum » Microsoft Access Training and help » access+database+training - Cross tab query?
|
|
|
The UK's most regular Training information: See also: |
|
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
access+database+training - Cross tab query?
Resolved · Low Priority · Version Standard
Reply Mon 26 Feb 2007, 09:56Delegate Andrew said...
Andrew has attended:
Access Introduction course
Access Intermediate course
Cross tab query?
How would I create a basic cross tab query?
For upcoming training course dates see: Pricing & availability
RE: 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
|