Adding Sequential numbers to a new feld in access table.

  • Thread starter Thread starter rjcmi
  • Start date Start date
R

rjcmi

I am working with a table which is actually a merge of 14 other
tables, therefore there is no real index key.

Table 1 Index was 1-5000
Table 2 index was 1-5000

In the merged database there are about 52,000 records, but no index
key.

I added a field to the table named Index and would like to populate
that field with a unique index number.

Does anyone have any ideas on how I could create an update query which
would add 1-52,000 to this field.

Thank you for your help.
 
rjcmi said:
I am working with a table which is actually a merge of 14 other
tables, therefore there is no real index key.

Table 1 Index was 1-5000
Table 2 index was 1-5000

In the merged database there are about 52,000 records, but no index
key.

I added a field to the table named Index and would like to populate
that field with a unique index number.

Does anyone have any ideas on how I could create an update query which
would add 1-52,000 to this field.
Click to expand...


Not with just that information. OTOH, why not just add an
autonumber field and let Access fo it for you?
 
Back
Top