Creating DB Tables using SQL

Does anyone know how to create a table in an Access database using SQL, creating a primary key field which increments automatically?

CREATE TABLE Test (ID AutoIncrement Constraint PrimaryKey PRIMARY KEY, OtherField TEXT);

Roger

Thanks a lot

Incidentally... :)

That's called DDL (data manipulation language - a subset of SQL) the other one is DML (data manipulation language - SELECT and all that lark)

Geek signing off! :D