access+database+training - Cross tab query?

The UK's most regular instructor-led training courses.
Training information: access+database+training · Microsoft.access.courses · Microsoft Access Training uk
See also · microsoft access training · access vba courses · access database course

Resolved · Low Priority · Version Standard

Cross tab query?

Andrew has attended:
Access Introduction course
Access Intermediate course

by - delegate Andrew [1 post] (2007 Feb 26 Mon, 09:56) Reply

How would I create a basic cross tab query?

Version	Date	Location	Places available	Book	Next place rate:
Access VBA 2 day course
Version	Date	Location	Places available	Book	Card	Invoice
2003	2008 Sep 4 Thu + 5 Fri	Southwark	0	FULL
2003	2008 Oct 20 Mon + 21 Tue	Southwark	6	book now	£450	£485
2003	2008 Nov 6 Thu + 7 Fri	Southwark	7	book now	£345	£399
2003	2008 Dec 4 Thu + 5 Fri	Southwark	7	book now	£345	£399
2003	2009 Jan 8 Thu + 9 Fri	Southwark	7	book now	£345	£399
2003	2009 Feb 5 Thu + 6 Fri	Southwark	8	book now	£275	£399
Full Schedule: See all 15 Access VBA course dates. Bookings currently available until 5th November 2009.

RE: cross tab query?

by - trainer Tracy platinum contributer [586 posts] (2007 Mar 5 Mon, 13:16) Reply

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

· Material covered on a Microsoft Access Course
· MS Access: Access your Personal Information with Ease
· Microsoft Access Training Unleashes the Power of the Pivot Table
· Want to Become the Office Hero? MS Project Training Could be the Answer
· Access VBA Handling Errors and Debugging Code

Access tip:

Run with the total

Often when creating reports with lists of transactions it can be useful to have a column which totals the transactions as the report progresses.

Using the Sum function gives the total for the whole group, not a running total.

Access provides an easy method of achieving a running total.

Click on the text box containing the data you wish to contain the running total.
Select the Data tab
Click in the Running sum option
Click the down arrow to view three options
Ø No

§ This Item is not a running total

Ø Over Group

§ This Item is a running total which will reset to zero with each new group value

Ø Over All

§ This Item is a running total which will total over the whole report