Difficult Graph Needed

[turtle]

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

[jimfortune]

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