now function

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello, I want to know how many people on the access data aren’t old enough to
vote? The age requirement is 21. I want to be able to list it up by using
the "NOW" function in query mode, but wasn't sure what I have to put in the
criteria to get that information out. My date format is YYYY/MM/DD
 
You can try something like

Where [BirthDateFieldName] < DateAdd("yyyy",-21,Date())

The DateAdd will take 21 Years from the current date, and the criteria will
bring all the people that there date of birth smaller from that resault
 
Back
Top