I have an access table with a textfield – end of year: mm-dd-yyyy (31-12-2009) but I need to change the format to yyyy-mm-dd (2009-12-31) it should be done in a query but I need help to build this query. I have uploaded the accessdatabase [login to view URL]