Column-based Access Reports

[JLCIV]

I am having trouble trying to figure out how to create a report which orientates the "Detail" section of the report in a column rather than a row.

Specifically, I have a table where each month we collect 20 different data points. The Mth/Year and the 20 data points represent a row/record. What I would like my report to do is create a table format where the columns represent the 12 months for the given year and the rows are the 20 different data points. I can't figure out how to do this...

JAN FEB MAR APR MAY...
Data1
Data2
Data3
Data4
Data5
...

I've tried to do a cross-tab query but I have to create an individual query for each data point and then create individual sub-reports for each query and stack them in a report. I hoping there is an easier, more efficient way to do this.

 

[dhookom]

Are we supposed to guess what your original table structure is? I expect it isn't normalized but can't be sure. If each data point is a field (like a spreadsheet) then you can normalize your data first with a union query and then create a crosstab from the union query.

There is at least on FAQ in this forum that suggests how to create your report from normalized data.

Duane MS Access MVP
[green]Ask a great question, get a great answer.[/green] [red]Ask a vague question, get a vague answer.[/red]
[green]Find out how to get great answers faq219-2884.[/green]