creating table and feilds

[didgydont]

hi all
im trying to create new table in a mdb so far it creates the fields but as the
wrong data type i would like to set price as a currency with genral formatting are there any guids on data types to suit this code ?

Conn.Execute("CREATE TABLE Records(TransID INTEGER NOT NULL,Item VARCHAR(40) NOT NULL,Price CURRENCY NOT NULL,Sold DATE  NOT NULL)")

 

[didgydont]

sorry dont worry about this the formatting doesnt matter

 

[Tom]

What datatype is it making for your Price column?

 

[didgydont]

it was making currency but i was afraid the $symbol in access would affect vb so it is fine as it is thank you for your reply