Update query - sequence problem

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi there

I have a field needing primary key status. Within the field, there are
currently about 600 records with unique values. The remainder have been
allocated: UNASSIGNE-000_000000/001

The input mask is as follows: LLLLLLLLL\-999\_999990/999;0;-

I would like to run an update record query, allocating a unique
number to every record, preferably in sequence (please refer below). Is this
possible?

For example:
UNASSIGNE-000_000000/010
UNASSIGNE-000_000000/011
UNASSIGNE-000_000000/012
etc

Really appreciate your help

Will
 
Thanks Allen. I couldn't understand below so I did it manually. After I
attend the VBA course I will look into your suggestions below.

Best wishes
Will
 
Back
Top