Pivot table

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

Resolved · High Priority · Version 2007

2 posts

ReplyMon 8 Jun 2009, 17:01Delegate Daljit said...

Daljit has attended:
Access Intermediate course

Pivot table

how do i create a pivot table with 2/3 rows and multiple columns

Version	Date	Location	Places available	Book	Next place rate (£)
Access Intermediate 1 day course
Version	Date	Location	Places available	Book	Pay by Card	Pay by Invoice
2007	Tue 23 Mar 2010	Bloomsbury	3		£224	£225
2003	Tue 30 Mar 2010	Bloomsbury	6		£199	£204
2003	Thu 22 Apr 2010	Southwark	5		£195	£200
2007	Tue 27 Apr 2010	Bloomsbury	4		£224	£225
2003	Fri 28 May 2010	Bloomsbury	9		£156	£161
2003	Wed 16 Jun 2010	Bloomsbury	8		£95	£100
Full Schedule: See all 20 Access Intermediate course dates. Bookings currently available until 17th December 2010.

870 posts

ReplyTue 9 Jun 2009, 07:29Trainer Rajeev said...

RE: pivot table

Dear Daljit

I believe that you have asked this question twice. I have already answered your previous query and hopefully you would have found it useful!

Kindest Regards

Rajeev Rawat
MOS Master Instructor 2000 and 2003
MCAS Master Instructor 2007
MCT

Mon 15 Jun 2009: Automatically marked as resolved.

· How Microsoft Access grows with your company
· Quick MS Access Training: Creating Custom Database Tables in 12 Simple Steps
· Happy Table Relationships In Access 2007
· What's In A Name? Creating A Company Personnel List Using Microsoft Access
· Have You Ever Wanted To Create A Combo Control On An Access Form?

Please browse our web site to find out more about
access course microsoft training and other Microsoft training courses.

Access tip:

Compact database automoatically

To ensure optimal performance, you should compact and repair your

Open the Access database or Access project that you want Access to compact automatically.
On the Tools menu, click Options.
Click the General tab.
Select the Compact on Close check box.

View all Access hints and tips