UPDATE query not working with date a value

[stringman]

Hello,

I am having a problem w/ my UPDATE statement when the date value is included in the statement. I have tried surrounding the date variable (strDate) in "#" and w/ and w/out single quotes to no avail. I doesn't matter if I dimension strDate as a string or a date. I know there must be a simple solution. In short, the UPDATE statement looks like this:

strSQL = "UPDATE tblTasks SET POC = '" & strPOC & "', Date = #" & strDate & "#, Task = '" & strTask & "' WHERE id = " & lID & ";"

If I remove

Date = #" & strDate & "#,

then the query works.

These also fail:

Date = #'" & strDate & "'#,

Date = '#" & strDate & "#',

Date = '" & strDate & "',

Any help would be greatly appreciated. Thanks.

Ken

 

[RuralGuy]

If your field is really named "Date" then you will drive Access nuts and you need to change the name of the field. Date is a reserved word.

 

[stringman]

Thanks. Problem fixed by placing brackets around the field name in the UPDATE statement. No fileds named Date for me.

Ken

 

[RuralGuy]

Thanks for posting back.