Go Premium for a chance to win a PS4. Enter to Win

x
?
Solved

Current year and previous years calculations

Posted on 2013-11-26
2
Medium Priority
?
464 Views
Last Modified: 2013-11-26
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
Comment
Question by:Kdankwah
2 Comments
 
LVL 49

Expert Comment

by:Dale Fye
ID: 39677810
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
 
LVL 21

Accepted Solution

by:
Boyd (HiTechCoach) Trimmell, Microsoft Access MVP earned 2000 total points
ID: 39678576
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

Get your Disaster Recovery as a Service basics

Disaster Recovery as a Service is one go-to solution that revolutionizes DR planning. Implementing DRaaS could be an efficient process, easily accessible to non-DR experts. Learn about monitoring, testing, executing failovers and failbacks to ensure a "healthy" DR environment.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

Lost Word File? Eagerly, need it back? Read ahead; this File Recovery guide is for you.
Windows Explorer lets you open cabinet (cab) files like any other folder. In VBA you can easily handle normal files and folders, but opening and indeed creating cabinet files takes a lot more - and that's you'll find here.
The view will learn how to download and install SIMTOOLS and FORMLIST into Excel, how to use SIMTOOLS to generate a Monte Carlo simulation of 30 sales calls, and how to calculate the conditional probability based on the results of the Monte Carlo …
If you’ve ever visited a web page and noticed a cool font that you really liked the look of, but couldn’t figure out which font it was so that you could use it for your own work, then this video is for you! In this Micro Tutorial, you'll learn yo…

916 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question