Report Groupings

[Vergy39]

I have a very large report that I am trying to create, but having issues with formatting it the way I want. I am able to format the report by Weekending date like this:

Weekending Reason1count Reason1amt Reason2count Reason2amt

In this report, I have 20 reasons which means the report will be 41 columns wide. I want to list the reasons on the left side of the report and then the Weekending Dates as the Headers. Is there an easy way to do this. I think it might be with how the query is written, but cannot figure out how to do a "Group By" for the ReasonID's. Any assistance is greatly appreciated.

Thanks
David V

 

[vbaInet]

Weekending Reason1count Reason1amt Reason2count Reason2amt

In this report, I have 20 reasons which means the report will be 41 columns wide.

There's obviously a flaw in your design. You need to normalize. In Excel it's perfectly fine to create the Reasons in a columnar fashion but Access is a database and things are not done this way. Here are some links on normalization:

http://support.microsoft.com/kb/283878
http://r937.com/relational.html
http://www.deeptraining.com/litwin/dbdesign/FundamentalsOfRelationalDatabaseDesign.aspx

Once you've normalized everything will fall into place.