Recursive total

[Romulus]

I have a report based on a query that conunts items based on date elements, sorted by year and month.
After each year I have a subtotal and a grand total at the end of report,
I need do have a recursive total on each month. New month total = Last month total + new month count value returned by query

Example
Year Month Count Total
2007
January 5 5
February 10 15
March 4 19
Total 2007 19 19


2008
February 2 21
May 8 29
June 4 33
Total 2008 14 33
Grand Total 33

Thank You

[CJ_London]

depends on how your data is structured but your would either use a subquery or the dcount function

something like

Total: (SELECT count(*) FROM myTable as T where Monthnum<=myTable.Monthnum)
or D

Total: COUNT("*","myTable","Monthnum<=" & Monthnum)

Both of these assume Monthnum is a number - 1=Jan, 2 =Feb etc