help needed to create table for MS Access

[FASTian]

I need to create a new table in MS Access which has an auto number field as primary key. Thanks

[Hesham Amin]

in database window : Select tables Click new Design view -> OK set Fieldname = (your Filed name) and datatype = AutoNumber click primary key from toolbar. Save table.

[FASTian]

well actually i needed to do this through a SQL query.

[Hesham Amin]

FASTian wrote: well actually i needed to do this through a SQL query. you should tell me :) Create table ABC(MyID COUNTER primary key )

[FASTian]

sorry forgot to mention that :).....really appreciate your help thanks