I have had this happen to me also. If you run through the entire recordset before writing to the Control it should provide the correct value. I.E:
rstTotals.moveFirst
rstTotals.moveLast
I am not sure what causes this problem except that unlike a standard query, ADO does not always loop...
This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
By continuing to use this site, you are consenting to our use of cookies.