Query that returns applicants over age 18

[Guest]

I have a querty that I want to look at DOB field and calculate if applicant
is over age 18 w/o having to change the ">" date each time I run it.

 

[Allen Browne]

Try this in the Criteria row of your query under the DOB field:

<= DateAdd("yyyy", -18, Date())

 

[Guest]

Beautiful .... Thank you.

Try this in the Criteria row of your query under the DOB field:

<= DateAdd("yyyy", -18, Date())