Query

[leighms]

I am in the process of developing a new Database in Access 2007, it is for survey results. I want to be able to report on specific reason codes by the month, ideally the report would appear as below;
Example:
Jul Aug Sep Oct
Deceased 6 5 8 9
Written off 2 3 1 5
Other 4 2 2 4

I cant seem to create a query that will get the information so i can transfer it to a report
Help please?????

 

[CBrighton]

You want a crosstab query.

I rarely use them so won't try to explain further, but the wizard should be able to make that for you. If not do a google search for "crosstab query".

 

[Alansidman]

Look at this video

http://www.datapigtechnologies.com/flashfiles/crosstab.html

Alan