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.

Surface Pro (2017) vs Surface Pro 4

20 groundbreaking 3D animation techniques

How to mine Bitcoin on Mac