Originally Posted by
autiger58
This is probably simple but for the life of me I can not figure this out.
I have a table with 25 fields with one field being a date field named [date1] in a table named TEST with the the format of mm/dd/yyyy. I want to convert the field with an update query from mm/dd/yyyy to mmddyyyy.
So I start Query Design, Select the TEST Table, Place date1 in the Field: area which populates the Table: area with TEST. In the Update To: area I put Format([date1],"mmddyyyy") of which I get the response from Access that I must have a destination field when I run it. I want to UPDATE the date1 field with the new format and not create a new field.
Anyone know what I am doing wrong?
Also, is there going to be a type mismatch error trying to update a field from 00/00/0000 to 00000000?
Thanks,
Michael