Try using a recordset. Create the Sum beforehand (in a query)
That's if I come online over the weekendits the end of my work day here but i'll be keeping up to date on this over the weekendthanks for all ur time so far
![]()
Good man!I have found an interesting suggestion and i'm starting to develop some thoughts,
I believe i have found an example of what you meant by "use recordsets" earlier, basically get every unique value i want into a recordset or a temporary table, increment the quantites against those so i can simultaneously track every rolling total without any "Dsum"age?
dim rs as dao.recordset, intSumQty as long
set rs = currentdb.openrecordset("SELECT ...", dbopendynaset)
do while not rs.eof
intSumQty = intSumQty + rs!Quantity
rs.edit
rs!Quantity = intSumQty
rs.update
rs.movenext
loop
rs.close
set rs = nothing