Reporting in columns

G

Gargamil

I know this is an age old question but for the life of me I cannot remember
the answer. I have a table that returns results in various categories
collated by month. So one month per record.

How do I report that as one month per column?? Showing each category as a
separate line item on the report.

g
 
J

John Vinson

Gargamil said:
I know this is an age old question but for the life of me I cannot remember
the answer. I have a table that returns results in various categories
collated by month. So one month per record.

How do I report that as one month per column??
Click to expand...

Create a Crosstab query based on the table, and base your form on this
Query. The Query Wizard will offer a crosstab as one of the options, and/or
see Crosstab in the online help.
 
G

Gargamil

This is fine however it doesn't return the row headings that I need.
Picture a table with say, 6 fields. When displayed as a table each record
represents a month, the first record the month and the other 5 the data. If
I use the pivot table wizard it will display the results grouped by the
VALUE in one of the columns, what is won't do (at least as far as I can see
in Access) is group by the field.

ie I want
Date A B C D E
1/1/2004 4 5 6 6 7
1/2/2004 6 7 8 9 0

to display as
1/1/2004 1/2/2004
A 4 6
B 5 7
C 6 8
D 6 9
E 7 0

This is easy in Excel since it displays the row headings on the chart.
Access does not. Can any MVP give me a response to this please??

g
 
Top