By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
459,688 Members | 1,900 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 459,688 IT Pros & Developers. It's quick & easy.

Difficult Graph Needed

P: n/a
I need to graph the following

StartDate $atstart EndDAte $atEnd
12/20/04 100 2/20/05 100
12/10/04 50 1/1/05 50

basically when I start a job i want to take 50% of the budget and when
i finish take the other 50%.

My graph data points would look like this.
12/04 150
1/05 200
2/05 300

How can I get this to work? Thanks

Nov 13 '05 #1
Share this Question
Share on Google+
1 Reply


P: n/a
turtle wrote:
I need to graph the following

StartDate $atstart EndDAte $atEnd
12/20/04 100 2/20/05 100
12/10/04 50 1/1/05 50

basically when I start a job i want to take 50% of the budget and when i finish take the other 50%.

My graph data points would look like this.
12/04 150
1/05 200
2/05 300

How can I get this to work? Thanks


This worked for me using A97:

tblBudget:
BudgetID StartDate EndDate TotalBudget
1 12/20/04 2/20/05 $200.00
2 12/10/04 1/1/05 $100.00

qryDisplayMonths:

SELECT Format([StartDate], 'm/yy') AS DisplayMonth,
DateSerial(Year([StartDate]), Month([StartDate]), 1) AS theMonth FROM
tblBudget UNION SELECT Format([EndDate], 'm/yy') AS DisplayMonth,
DateSerial(Year([EndDate]), Month([EndDate]), 1) AS theMonth FROM
tblBudget;

OUTPUT:
DisplayMonth theMonth
12/04 12/1/04
1/05 1/1/05
2/05 2/1/05

qryDisplayCumulativeMonthlyBudget:

SELECT A.DisplayMonth, Nz((SELECT Sum(Nz([TotalBudget]) / 2.0) FROM
tblBudget WHERE StartDate < DateAdd("m", 1, A.theMonth)))+Nz((SELECT
Sum(Nz([TotalBudget]) / 2.0) FROM tblBudget WHERE EndDate <
DateAdd("m", 1, A.theMonth))) AS Budget FROM qryDisplayMonths AS A
ORDER BY A.theMonth;

OUTPUT:
DisplayMonth Budget
12/04 150
1/05 200
2/05 300

Was that the part you needed help with?

James A. Fortune

Nov 13 '05 #2

This discussion thread is closed

Replies have been disabled for this discussion.