please give me examples of what you have and what you want, including any zeros and empty numbers
wait a sec ...
just looked at your code. why do you have two separate loops? either use only one loop or after the first loop use rs.movenext to make sure you are at the first record.
The first loop is to display the records, and the second is the one to adjust the numbers. I added mySpots.movefirst before the second loop now (which I should have done anyway) and it finally worked right.