Problem with Cdate field not working in Update Query

Joined
Aug 13, 2012
Messages
1
Reaction score
0
Good afternoon all,
I've succesfully used CDate to format a text field in my Access Select Query. I encounter a problem, however, when I switch the same Select Query to an Update Query.

Error message:

Syntax error (comma) in query expression 'Tbl_Inventory.[Cdate(Mid([Added],3,2) & "-" & Mid([Added],5,2) & "-12")'.

As I said, I don't understand why my syntax works fine for the Select and not for the Update. Also, the UpdateTo field is a date/time field, but I also tried making it a text field just for giggles. Neither worked.

Thanks in advance for you assistance.

Brandi
 
Back
Top