• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 467
  • Last Modified:

Current year and previous years calculations

To piggyback on the thread below:

http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28302728.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
0
Kdankwah
Asked:
Kdankwah
1 Solution
 
Dale FyeCommented:
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.
0
 
Boyd (HiTechCoach) Trimmell, Microsoft Access MVPCommented:
Now hat you have added a column for fiscal year then this is definitely possible to do.

 I am working on an example for you now. Be back shortly...

Edit...   Here it is
MTD-YTD-testing-HiTechCoach3.accdb
0

Featured Post

Concerto's Cloud Advisory Services

Want to avoid the missteps to gaining all the benefits of the cloud? Learn more about the different assessment options from our Cloud Advisory team.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now