Im a noob at SQL and Microsoft Access. Only been using online tutorials for past week. I am using DD-MM-YYYY instead of the american MM-DD-YYYY format in my data base. What im trying to do is to write a query to only display individuals in my data base that are aged 20-25 on a specified date (6/6/2002) 'Data type mismatch in criteria expression' is the error i keep getting and i dont understand why. Is it that the query would only work when the date format is in MM-DD-YYYY? I already set the 'dOB' field to date/time format and it has accepted the DD-MM-YYYY format so i doubt it. Can anyone help?
