"KhalilS" wrote in message
...
how do you create an auto number field in Access using DDL? the Auto
things
it an Auto..!

Example:

CREATE TABLE Policies
(policy_id AUTOINCREMENT
,policy_start_date DATETIME
,policy_renewal_date DATETIME
,premium_payable CURRENCY
,other_policy_details TEXT(255)
,CONSTRAINT pk_Policies PRIMARY KEY (policy_id)
)


Sincerely,

Chris O.