increment field in query

  • Thread starter Thread starter Sue B.
  • Start date Start date
S

Sue B.

Hello,

I would like to append records with no key to a table with
a key by making the key as I go, just using the max key
(or I could enter it as a parameter) +1 for each appended
record. The table has 5015 records, so I want the first
appended record to be 5016, the second 5017, etc. Thank
you in advance for any help.
 
the following is untested, so recommend you try it on a
copy of your db. append this calculated value to the
table's primary key field:

Nz(DMax("FieldName", "TableName") + 1, 1)
 
Back
Top