- 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
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