Link to home
Start Free TrialLog in
Avatar of Kdankwah
KdankwahFlag for United States of America

asked on

Current year and previous years calculations

To piggyback on the thread below:

https://www.experts-exchange.com/questions/28302728/MTD-and-YTD-calculation.html

I would like to create a report that will show side by side the Current Year and the Previous Year calculation for MTD and YTD.  How do I do the calculations for the previous year.

I am attaching  the database with fiscal years split Current to be "14" and previous to be "13". and also a sample of the report that I am looking for.

Thanks
MTD-YTD-testing-HiTechCoach2.accdb
Sample-report.pdf
Avatar of Dale Fye
Dale Fye
Flag of United States of America image

Don't know what your final resolution was on your data structure (and am unable to download your database at the moment), but that is one of the reasons I mentioned changing your data structure and inserting a Date/Time field into your table in my response yesterday.
ASKER CERTIFIED SOLUTION
Avatar of Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP 2010-2015
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial