AutoNumber in Query

[Guest]

I am linking to a SQL table via ODBC. I want to use an append query to insert data into a table that has a keyid field

The keyid field just must be unique and does not have any true relationship with the data

Can I use an "autonumber" approach? Is there a function that returns an autonumber value

If not, what other technic could I use

THANKS

MEG

 

[Nikos Yannacopoulos]

Meg,

If your keyid field is autonumber you need not worry much about it in the
append query; that is to say, append all the other fields (leaving the keyid
field out of the query altogether), and the autonumber will assign the keyid
values on its own.

HTH,
Nikos

I am linking to a SQL table via ODBC. I want to use an append query to

insert data into a table that has a keyid field.