Record counter based on value from another field
Posted on 2014-01-22
I am new to VBA and struggling with how to accomplish the following:
I need to assign consecutive numbers to each record in a table, based on the value in another field. The counter must re-set each time the value in the other field changes.
I am currently trying to accomplish this by writing an expression for the counter_field in an append query, but I think I should also be able to do with an update query, but I am not clear how to refer to the 'prior-record' (if prior-record fund_Name <> current record fund_Name, etc.)
Ideally, I would like to figure out how to do it with VBA, declaring record-set, counter and using rowcount, but I am lost. Any help much appreciated.