Sorry if I was vague. I have a parent table , A, which holds summarized values of transaction table, B.

I scan through table A and sum all the records matching A.value. Then I store that sum qty in table A. Go to the next record in table A and then again scan table B matching A.value.

The code runs with out errors, it just seems to skip records.
When I substitute Do While - EnndDo for the Scan - EndScan, it works as I expect.

Thanks again.

GSD