sql INSERT statement..help

[loones]

im trying to insert a new record in the table but syntax error message display out, the following is my statement:

qry = "INSERT INTO template Time VALUES " & time & ";"

template is my table name
Time is the column name
time is the value i wish to enter

 

[The Stoat]

im trying to insert a new record in the table but syntax error message display out, the following is my statement:

qry = "INSERT INTO template Time VALUES " & time & ";"

template is my table name
Time is the column name
time is the value i wish to enter

Hi,

try this

Docmd.Runsql("INSERT INTO template Time VALUES (#" & time & "#);"


The Stoat