AutoNumber in Query

  • Thread starter Thread starter Guest
  • Start date Start date
G

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

MEG said:
I am linking to a SQL table via ODBC. I want to use an append query to
Click to expand...
insert data into a table that has a keyid field.
 
Back
Top