|
You can use SQL for that. The first thing to keep in mind is that like any real DBMS, tables in 9 are unordered. Records can appear in any random order. If you want to see some particular order based on a field, and thus a particular running total based on that order, you have to use ORDER BY. (Release 8 is a bit hackish from a DBMS perspective because it pretends that tables have an intrinsic order... ) OK, so suppose you have an attribute field that gives the order of each record. Suppose you have a table called Sales and there is a sales ID field that gives the order of each sale such that each ID is unique and higher ID values indicate later sales. Suppose you also have an Amount field. You want to create a table that lists all sales in order by sales ID with the Amount of each sale and a Running Total of amounts for that sale and all prior. Use a query: SELECT T1.mfd_id, T1.Amount, Sum(T2.Amount) as RunningTotal FROM Sales AS T1 INNER JOIN Sales as T2 ON T1.mfd_id >= T2.mfd_id GROUP BY T1.mfd_id, T1.Amount ORDER BY T1.mfd_id, T1.Amount; The above is an inner join that joins the Sales table to itself. I used the mfd_id field instead of cobbling up a fake sales ID field. I used simple field and table names so no need to bracket [ ] them. You could, of course, Style the RunningTotal field. [Oops... don't need T1.Amount in the ORDER BY...] 
Attachments:
 running_total.png
|