Jump to content

Nightwisher87

Member
  • Posts

    1
  • Joined

  • Last visited

  • Donations

    0.00 USD 
  • Country

    United Kingdom

About Nightwisher87

Nightwisher87's Achievements

0

Reputation

  1. 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?
×
×
  • Create New...