Microsoft Access - Increment Number Using Update Query
I need to run an update to increment an ID number, starting at a certain value and adding 1 for each record.
Currently I have a separate table (named fCallID) that contains the starting number in a field called newCallID. The current value is 131200
I need to update the CallID field in the fCalls table. The CallID field is blank for all 50000 records. I want to start with the newCallID value of 131200 and add 1 for every CallID in the fCalls table.
I want to run this one time from a query. Note: the primary key of fCalls is mid.