AutoNumber w/ SQL

[asm338s]

Hi Everyone:

Does anyone know how to create an AutoNumber(sequence) field using SQL. I am populating my table from a couple of tables. For the purpose of having a primary key, I need a sequence number that should increment itself everytime a record is added.
Any help appreciated.

Thanks

 

[tlbroadbent]

Why not just set the column as an Autonumber and let Access increment it? Terry L. Broadbent
FAQ183-874 contains tips for posting questions in these forums.
NOTE: Reference to the FAQ is not directed at any individual.