hi

i need to create a autoincrementing primary key field in a access database
thru a sql command, (that kind of field is called a long integer in access,
and it autoincrements when a new record is added)

the following gets the field type created, but it doesn't auto increment.

CREATE TABLE tblCustomers ([Last Name] TEXT(5) NOT NULL, CustomerID UniqueID
INTEGER NOT NULL PRIMARY KEY UNIQUE)

what would be the word to make it auto increment?

thanks

ray