I have a dilema. I can't seem to grasp the differences between 2000 and 2002. I need to create a query in a DateTime field that will return the dates in mm/dd/yyyy format. They way I used to do it Date: Format([DateTime],"mm/dd/yyyy") does not work. I get the error message "Undefined function '[Format$]' in expression"
I guess from what I have been able to read in the HELP section I need to learn SQL. Along with the answer for the above question, does anyone know a good SQL reference?