I need to change the format of the date in an MS access table from m/dd/yyyy to mmddyyyy. I just used the advice given here to remove the dashes from the ssn field and it work beautifully. is there a way to use the same update query to do both the dash removal from the ssn and reformat the date to mmddyyyy?