MS ACCESS SQL code ??

[Leon1977]

I need to write a Create table SQL script for MS ACCESS
but I need a autonumber field and a double (fixed 2)
How should I define theese datatypes

Create table table_name(
id int primary key /autonumber/,
price float /fixed(2)/
)

something like this

 

[TorF]

This should works, but it miss the double fixed2:

DoCmd.RunSQL "CREATE TABLE MyTable (id COUNTER PRIMARY KEY, price FLOAT)"

 

[Leon1977]

OK Thanx a lot
counter works but I still need the double (fixed 2)
!!!