CREATE TABLE error

[TJones8]

I have a form that creates a table for some data from another table to be filtered into. This is the quick snippet i use :-

strSQL = "CREATE TABLE FilterStationTimes (Id INTEGER, Time LONG, Duration LONG, dTime LONG);"

DoCmd.RunSQL strSQL


for some reason, i get an error 'Syntax error in field definition', but i can't see what i've done wrong

TIA

 

[JoanneM]

Afternoon


Time is a worksheet function so maybe if you call Time ATime you will have a better effect

I did this and it created the table

regards

Jo

 

[TJones8]

Aha, worked perfectly now thx
even though a few of my other tables have a 'Time' field, but they were created manually, so i guess that's why they work.

Thx