Would anyone care to provide asssitance on how I may to able to produce a report as if I am creating an excel worksheet based on data entered into my table monthly? Here is an explantion of what I am trying to achieve in Access.

I have 2 tables: One that stores my contacts list, and another that I use to record the date of the courses I conduct for my clients and the number of attendees. the number of courses and dates are not fixed per month and may vary. I have created a form to enter this data and table to store it

Eg.

Client AAA
Course date: 1/2/2009
No of attendees: 3

Client BBB
Course date: 1/2/2009
No of attendees: 5

Client CCC
Course date: 1/2/2009
No of attendees: 1

Client AAA
Course date: 15/2/2009
No of attendees: 2

Client BBB
Course date: 15/2/2009
No of attendees: 4

Client CCC
Course date: 15/2/2009
No of attendees: 1

Client AAA
Course date: 6/3/2009
No of attendees: 3

Client BBB
Course date: 6/3/2009
No of attendees: 5

Client CCC
Course date: 6/3/2009
No of attendees: 7

I would like to create a report that would print out the date of the courses and number of attendees in table form.

Eg

Company 1/2/2009 15/2/2009 6/3/2009 ... total

AAA 3 2 3 ... 8

BBB 5 4 5 ... 14

CCC 1 1 7 ... 9

You need to make a cross tab query. You won't get a total that way, but you can put the total in a header or footer. Do you need help with that?

__________________
mmcdonal

Look it up at: http://wrox.books24x7.com