Cumulative Sums

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a table that holds our monthly budgets. In a query for YTD totals I need to calculate the YTD bufgets being the sum of all previous months budgets. The structure of the table is such that each record in the table has a Period Name being the month name, and a start and end date for example start 11/1/2003 and end 11/30/2003 and a bufget amount.
 
George

From your description, I can't tell if you are describing a "narrow" table
design (4 columns - PeriodName, StartDate, EndDate, BudgetAmount), or a
spreadsheet-like design, with information for each period as a set of
columns.

If the former, isn't the "YTD of Previous Months" = "YTD" - "CurrentMonth"?

More info, please...
 
Back
Top