autonumber

[Dave_D]

Can a new autonumber field be created thru a make table query? What's the appropriate syntax?

[Bulzie]

I don't think so. Usually what you can do is create the table ahead of time(with the autonumber and related fields), then use an Append query to add the records to that table. Or you could do the make table, then add the Autonumber field afterwards. Not sure if you are able to do the manual parts or want it automated. Maybe in code you could append records and use a counter to create an unique numeric incremental field?

[JoeM]

You could run code after the MakeTable Query to add the Autonumber field.
See: http://stackoverflow.com/questions/2...tonumber-field