KhalilS said:
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.
