>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.
>

Use SCAN WHILE rather than SCAN FOR for the inner loop.

Tamar