G
Guest
I need to add a sequence number for multiple records with the same primary ID.
Basically, I have multiple entries in a table for the same primary key (in
this case a customer ID). I need to add a field to the table and update it
with the record number for the customer ID.
For example, customer ID 12345 has 4 entries in the table. In the new
field, 'EventNumber', I want to number the events 1, 2, 3 and 4 respectively
(in order by a date/time field that already exists).
Anybody know how I can do this? Thanks!
Basically, I have multiple entries in a table for the same primary key (in
this case a customer ID). I need to add a field to the table and update it
with the record number for the customer ID.
For example, customer ID 12345 has 4 entries in the table. In the new
field, 'EventNumber', I want to number the events 1, 2, 3 and 4 respectively
(in order by a date/time field that already exists).
Anybody know how I can do this? Thanks!