"CREATE SEQUENCE" IN ACCESS SQL 1

[baybie]

Hello chaps, is it possible to use the CREATE SEQUENCE facility in access SQL for creating reference numbers of fixed length? e.g.

CREATE SEQUENCE CUST_ID
INCREMENT BY 1
START WITH 1000234
MAX VALUE 2000000
NO CYCLE;

 

[PHV]

Something like this ?
ALTER TABLE Cust ALTER COLUMN Cust_Id IDENTITY (1000234, 1);

Hope This Help, PH.
Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244

 

[baybie]

Thanks PHV, YOU'RE A STAR.

 

[baybie]

Actually it hasn't worked. Theres a syntax error, presumably where the first ( is...