MS Access problem

  theearlofsabden 13:20 28 Mar 09
Locked

Hi all

I have a database for people who use the community gym, there’s about 500 + people on it with various dates of birth and I need to run a query to find out how many people use the gym under the age of 20. In the criteria I’ve been putting */*/ 1989 but it doesn’t seem to be working as it’s giving me dates greater and less than this!

Any ideas please

Regards
Neil.

  Mike D 13:35 28 Mar 09

How about <01/01/89

  theearlofsabden 13:44 28 Mar 09

nope... returns nothing

  Chris the Ancient 15:24 28 Mar 09

In your query design matrix, use the criteria...

Between #01/01/89# And #31/12/09#

You need to put the # either side of the chosen date to let Access know that it is handling a date field.

You can see a typical example in the sample Northwind.mdb, provided with Access, in its Quarterly orders query.

This thread is now locked and can not be replied to.

Nintendo Switch review: Hands-on with the intuitive modular console and its disappointing games…

1995-2015: How technology has changed the world in 20 years

This abstract video touches on division in our technologic world

Best alternatives to iTunes for Mac | Best music players for macOS: Free your music from the…