stepping thru an access table calculating fields
Posted on 2011-03-01
I am trying to go thru an access table from start to end. I have an AMT - YTD_Total - Threshold_Amt - and Limit_Amt fields. I have to add the Amt Field to YTD_Total and I go thru peoples ID numbers. For exp.
rec1 Joe Blow id 12345 Amt - 5 YTD_Total - 5
rec2 Joe Blow id 12345 Amt - 10 YTD_Total - 15
rec2 Mary Blow id 67891 Amt - 20 YTD_Total - 20
rec2 Mary Blow id 67891 Amt - 30 YTD_Total - 50
I would need to update the field in the table I am steping thru as I go.
Is this possible and if so how would I do it? I have never stepped thru a table and updated as I go before.