date - age query

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

Guest

in design view have a DOB field (date of birth)

need the query to find those 18 and older....thus the criteria would need to
be a DOB that is:

< CurrentDate - 18 years

where Current Date is automatically supplied , not manually typed in....

am floundering around with the syntax.....
thanx
 
tried entering into criteria:

DateAdd('yyyy';-18;Date)


threw error on syntax......Access2002
 
worked great - thanks......I think I forgot to do all the )))) correctly at
the end in my attempt....!
 
Back
Top