Update query: Data type mismatch

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

David M C - 05 Sep 2006 15:27 GMT

Here's my code:

Do While currentDate <= tempFinish
strSQL = "UPDATE Forecast SET Forecast.totalValue = ""totalValue""
+" & dailyValue & " WHERE (((Forecast.calDate)=#" & Format(currentDate,
"mm/dd/yyyy") & "#));"
cmd.CommandText = strSQL
Debug.Print strSQL
cmd.Execute
currentDate = currentDate + 1
Loop

And here's the strSQL output in the immediate window:

UPDATE Forecast SET Forecast.totalValue = "totalValue" +263.4528 WHERE
(((Forecast.calDate)=#01/01/2006#));

However, I get a "data type mismatch in criteria expression" error. I don't
get this error if I remove the #'s, but none of the fields get updated. Any
ideas?

Thanks,

Dave

Reply to this Message

Duane Hookom - 05 Sep 2006 15:41 GMT

Try this:

Do While currentDate <= tempFinish
strSQL = "UPDATE Forecast " & _
"SET [totalValue] = [totalValue] + " & dailyValue & _
" WHERE [calDate]=#" & Format(currentDate, "mm/dd/yyyy") & "#"
cmd.CommandText = strSQL
Debug.Print strSQL
cmd.Execute
currentDate = currentDate + 1
Loop

Signature

Duane Hookom
MS Access MVP

> Here's my code:
>
[quoted text clipped - 22 lines]
>
> Dave

Reply to this Message

David M C - 05 Sep 2006 16:50 GMT

Thanks, sorted.

> Try this:
>
[quoted text clipped - 34 lines]
> >
> > Dave

Reply to this Message