I have a Date/Time field (1 Eye Exam Date) in an Access table but I need to update at Start time field with 1 Eye Exam Date plus 12:00:00 PM. I have tried updating the Start Time with 1 Eye Exam Date+" "+ 12:00:00 PM but I received a validation error. I have tried creating a time field with 12:00:00 PM in and adding the field together in an update query but that didn't work either, received a validation error. I am sure this have to do with the field type and I have the wrong format. I am not a developer. Any help would be greatly appreciated.