Running Total help

[Pcolaboy]

All,

I'm having serious trouble figuring out how to create running totals within records.

Here is an example row of a table with asterisks by the columns that I want to calculate a 'Month to Date' running total for: [DataDate]: 11/05/00 [Sales Revenue]*: 575.00 [Returns]*: 100.00 [Inventory Received]*: 250.00

Each record in this table has a unique date with the above fields. I am wanting to create a running 'Month to Date' field within this table for each of above fields for each day. The next day's record would find the value for the previous day's 'Month to Date' fields and apply the values for the current record to determine its 'Month to Date' value and so on. I do not necessarily want this to be 'Month to Date' but rather want to know what the accumulated values were on each day's record from a particular starting point (date). I'm populating this particular table with append queries drawing data from other tables.

I would greatly appreciate any input some of you out there could provide.

Thanks in advance,

Scott