Access 2010 How to show records as columns in report?

[VorLag]

The way I have my database set up, records are saved under a specific reporting date since that will never be duplicated. So, I have a field "Report Month" that I want to use in the report created by Access.

I would like the columns to be these report months so that I can do a quick comparison month-to-month and have it easier to see.

I also have a bunch of different fields in the various tables, so it'd be easier to have the report month be the column. How can I do this? I haven't been able to find any good resources, but it seems like it is possible.

 

[sheetspread]

How about writing a crosstab query as the report source?

 

[VorLag]

How do I set the fields to be the row lable AND value? I tried to set up a crosstab query, the only problem being that I almost want to completely transpose the fields I'm pulling into the query that will feed the report. I'm just not familiar with crosstab queries. Thank you for the tip!

 

[sheetspread]

Have two columns in the query for the field you wish to show in the column headings and as records.