Create table query

[Guest]

how do i write a create table query which should have
autonumber field. Any ideas people?

 

[MGFoster]

-----BEGIN PGP SIGNED MESSAGE-----
Hash: SHA1

CREATE TABLE MyTable (
MyAutoNumberColumn Counter,
Column1 Integer
)

In JET SQL the data type for an AutoNumber column is "Counter."

--
MGFoster:::mgf00 <at> earthlink <decimal-point> net
Oakland, CA (USA)

-----BEGIN PGP SIGNATURE-----
Version: PGP for Personal Privacy 5.0
Charset: noconv

iQA/AwUBQMi/boechKqOuFEgEQIXOgCgyyxxCRynuW4uPYNoBZMATTRgyT0Anj0j
WzkaKAnfJOTfVxjJ0tdaEFTk
=6uUb
-----END PGP SIGNATURE-----