Report data in month columns and year rows (1 Viewer)

Hey folks; I am trying to make a report that creates a simple chart of my data, which would look something like this:


Hopefully that example chart makes sense. There would be a column for every month, and a few extra rows for other years. I have a query which pulls the CalendarYear and CalendarMonth out of my table with all the dates, and I have used this to make other reports that organize the data by year. So I feel like I have the necessary stuff, I'm just not sure how to get the right report design I want.

Thanks for any advice. I'll be monitoring to respond to the follow-up questions

you haven't said how your data is structured but on the basis it is normalised, use a crosstab query to base your report on

use the report wizard initially to get your basic design - you'll then probably need to move the total columns from the left to the right

Thanks, CJ. I had read a bit about crosstab queries but did not make the connection. That did the trick.

And yes my DB is normalized. I understand the importance of that principle and how it affects everything, but I didn't want to launch into a discussion of DB design when asking a basic reports question.