This user guide provides instructions on how to deploy and configure both a StoneFly Scale Out NAS Enterprise Cloud Drive virtual machine and Veeam Cloud Connect in the Microsoft Azure Cloud.
Solved
MTD and YTD category report with a budget column
Posted on 2013-11-29
To piggyback on the link below:
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28304111.html
I have added a budget table to be used as part of the report. I need to add the budget column to the report on the database. I attach a replica of the report and how it should look like.
Thanks
MTD-YTD-testing-HiTechCoach3.accdb
replica.xlsx
http://www.experts-exchange.com/Microsoft/Development/MS_Access/Q_28304111.html
I have added a budget table to be used as part of the report. I need to add the budget column to the report on the database. I attach a replica of the report and how it should look like.
Thanks
MTD-YTD-testing-HiTechCoach3.accdb
replica.xlsx
[X]
Welcome to Experts Exchange
Add your voice to the tech community where 5M+ people just like you are talking about what matters.
- Help others & share knowledge
- Earn cash & points
- Learn & ask questions
-
9
5
14 Comments
First the budget tables need to be combined into the same table with a field for fiscal year just like you did in the MTD table.
Are the budge amounts per month (period) or a total for the year? I would assume by the name is is a budgeted amount for the year. Is that correct?
The exact same method I used for combining the MTD and YTD will apply to adding the budget amounts.
What part is giving you troubles in learning to do this yourself?
Are the budge amounts per month (period) or a total for the year? I would assume by the name is is a budgeted amount for the year. Is that correct?
The exact same method I used for combining the MTD and YTD will apply to adding the budget amounts.
What part is giving you troubles in learning to do this yourself?
Yes its for the year. I got into trouble because I did a join. Now that you mentioned I will combine it into the same table. That will work then.
Thanks a lot.
Thanks a lot.
Here is what I have so far:
SELECT mtd.[Fiscal Year], mtd.COSTCTR, mtd.CATEGORY, Sum(IIf([Month_id]=[EnterP
FROM mtd LEFT JOIN qryMTDYTDCostCTRCatPrevYea
GROUP BY mtd.[Fiscal Year], mtd.COSTCTR, mtd.CATEGORY, qryMTDYTDCostCTRCatPrevYea
HAVING (((mtd.[Fiscal Year])=[EnterFiscalYear]) AND ((mtd.COSTCTR)="7601"));
The trouble I am having is this: see the highlighted on the attached, the report is kind of repeating itself when I add the budget and the segment.
Thanks
highlighted.xlsx
SELECT mtd.[Fiscal Year], mtd.COSTCTR, mtd.CATEGORY, Sum(IIf([Month_id]=[EnterP
FROM mtd LEFT JOIN qryMTDYTDCostCTRCatPrevYea
GROUP BY mtd.[Fiscal Year], mtd.COSTCTR, mtd.CATEGORY, qryMTDYTDCostCTRCatPrevYea
HAVING (((mtd.[Fiscal Year])=[EnterFiscalYear]) AND ((mtd.COSTCTR)="7601"));
The trouble I am having is this: see the highlighted on the attached, the report is kind of repeating itself when I add the budget and the segment.
Thanks
highlighted.xlsx
I take it back. What I did was to add the two budget tables into the MTD with a fiscal year.
The budget file in excel format is attached.
Thanks
highlighted.xlsx
The budget file in excel format is attached.
Thanks
highlighted.xlsx
Sorry about that, here is the database with the budget column
MTD-YTD-testing-HiTechCoach3.accdb
MTD-YTD-testing-HiTechCoach3.accdb
Try the Attached:
MTD-YTD-testing-HiTechCoach4.accdb
MTD-YTD-testing-HiTechCoach4.accdb
Featured Post
Your application or website rely on your database to deliver information about products and services to your customers. You can’t afford to have your database lose performance, lose availability or become unresponsive – even for just a few minutes.
Question has a verified solution.
If you are experiencing a similar issue, please ask a related question
Ever visit a website where you spotted a really cool looking Font, yet couldn't figure out which font family it belonged to, or how to get a copy of it for your own use? This article explains the process of doing exactly that, as well as showing how…
- Microsoft Applications
- Windows OS
- Fonts Typography
- Web Browsers
- Microsoft Word
New style of hardware planning for Microsoft Exchange server.
The viewer will learn how to create a normally distributed random variable in Excel, use a normal distribution to simulate the return on an investment over a period of years, Create a Monte Carlo simulation using a normal random variable, and calcul…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses
Course of the Month14 days, 2 hours left to enroll
656 members asked questions and received personalized solutions in the past 7 days.
Join the community of 500,000 technology professionals and ask your questions.