Primary Key in Make Table query?

[fastrunr]

Within a make table query, is there any way to create an autonumber field and set it as the primary key of the new table?

Thanks!
Liz

 

[sfreeman]

CREATE TABLE Employees
(
EmpID Counter Not Null Constraint EmpID primary key
, First_Name TEXT(20)
, Last_Name TEXT(25)
, dob DATETIME
);

Sam_F
"90% of the problem is asking the right question.