Go Back   Access World Forums > Microsoft Access Discussion > Reports

 
Reply
 
Thread Tools Rate Thread Display Modes
Old 07-02-2019, 08:57 AM   #1
JoeBruce
Newly Registered User
 
Join Date: Jan 2017
Posts: 23
Thanks: 8
Thanked 0 Times in 0 Posts
JoeBruce is on a distinguished road
Report data in month columns and year rows

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

Code:
           Month1       Month2        Month3       (etc)     Total
Year1     TotalM1,Y1   TotalM2,Y1   TotalM3,Y1     (etc)    TotalY1
Year2     TotalM1,Y2   TotalM2,Y2   TotalM3,Y2     (etc)    TotalY2
Totals    TotalM1,allY TotalM2,allY TotalM3,allY   (etc)   Total allM,allY
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

JoeBruce is offline   Reply With Quote
Old 07-02-2019, 09:10 AM   #2
CJ_London
Super Moderator
 
Join Date: Feb 2013
Location: UK
Posts: 10,909
Thanks: 40
Thanked 3,538 Times in 3,419 Posts
CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice CJ_London is just really nice
Re: Report data in month columns and year rows

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
__________________
CJ_London
_______________________
A little thanks goes a long way. If you have found this post useful, please tick the thanks button
CJ_London is online now   Reply With Quote
The Following User Says Thank You to CJ_London For This Useful Post:
JoeBruce (07-02-2019)
Old 07-02-2019, 11:34 AM   #3
JoeBruce
Newly Registered User
 
Join Date: Jan 2017
Posts: 23
Thanks: 8
Thanked 0 Times in 0 Posts
JoeBruce is on a distinguished road
Re: Report data in month columns and year rows

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.

JoeBruce is offline   Reply With Quote
Reply

Thread Tools
Display Modes Rate This Thread
Rate This Thread:

Forum Jump

Similar Threads
Thread Thread Starter Forum Replies Last Post
Sales this month or year verses last years month or year Blitznb Reports 8 01-05-2012 01:43 PM
Getting a Month/Year on a report johnsmith1000 Reports 9 09-30-2010 07:44 AM
last month / year, current month year same query whitesmoke Theory and practice of database design 2 06-23-2006 02:07 PM
Report by year and month yessir Reports 7 01-04-2005 08:33 AM
Month by Month Report for the Year bkolbow Reports 0 01-12-2001 10:33 AM




All times are GMT -8. The time now is 03:12 PM.


Microsoft Access Help
General
Tables
Queries
Forms
Reports
Macros
Modules & VBA
Theory & Practice
Access FAQs
Code Repository
Sample Databases
Video Tutorials

Featured Forum post


Sponsored Links


Powered by vBulletin®
Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
(c) copyright 2017 Access World