424,688 Members | 1,893 Online
Need help? Post your question and get tips & solutions from a community of 424,688 IT Pros & Developers. It's quick & easy.

# calculating totals in a query

 P: n/a Performance_Date SumOfBudget_NOI CurrYTD_BudgetNOI_Total 1/1/2004 \$4,184,626.00 ? 2/1/2004 \$4,484,710.00 ? 3/1/2004 \$4,537,424.00 ? 4/1/2004 \$4,826,850.00 ? 5/1/2004 \$4,966,326.00 ? Can someone help? What I am trying to do is create a query that will end up looking like the bottom example. The above query is a calculated totals query with an aggregate sum function. What it is doing is summing up all the Budget_NOIs for the month of January and outputting it as shown (I got that done). And it will do that for every month as time progresses. What I need help doing is calculating the portion with the question marks. What I need it to do (below there is an example on how I want it to look) is sum up all the SumOfBudget_NOIs from January to the current month. For example, the February amount would be the sum of both January's and February's SumOfBudget_NOI. For March, it will be the sum January's, February's and March's SumOfBudget_NOI. For April, it will be the sum January's, February's, March's and April's SumofBudget_NOI. And so on for the other months to come. I really have no idea how to approach this problem. Any suggestions. THANKS! Performance_Date SumOfBudget_NOI CurrYTD_BudgetNOI_Total 1/1/2004 \$4,184,626.00 \$4,184,626.00 2/1/2004 \$4,484,710.00 \$8,669,336.00 3/1/2004 \$4,537,424.00 \$13,206,760.00 4/1/2004 \$4,826,850.00 \$18,033,610.00 5/1/2004 \$4,966,326.00 \$22,999,936.00 Nov 13 '05 #1