there are lot of ways in sql to diplay the running sums and sums(using group by,compute by, compute etc.,). Ok I have written one like. but How to create the resultset containing those running sums.
Printable View
there are lot of ways in sql to diplay the running sums and sums(using group by,compute by, compute etc.,). Ok I have written one like. but How to create the resultset containing those running sums.
I don't know how to do it with the datacontrols, but if you do it manually:
Dim db as Database
Dim rs as Recordset
Set db = OpenDatabase( MyDatabase.mdb, False)
Set rs = db.OpenRecordset( , dbOpenDynaset, dbReadOnly)
Now you can simply do a loop like
Do While Not rs.EOF
rs.Fields(0).Value
Loop
Check the help for the stuff you don;t know.. This is out of my head, but it's something real close to the above.
hope it helps
Crazy D