CREATE TABLE with decimal (1 Viewer)

[seany]

Can someone please help with this, it6 is having problem creating number field with 2 Decimal places

DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In decimal(10,2), Out decimal(10,2));"

 

[workmad3]

DoCmd.RunSQL "CREATE TABLE Temp (Speed_Band Text, Site_ID INTEGER, In NUMERIC(10,2), Out NUMERIC(10,2));"

hopefully the above will help.

You also might want to change the In fieldname to something else as In is an sql reserved word.