increment field in query

[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.

 

[tina]

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)