Kdankwah
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
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
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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.