age criteria

[Guest]

does anyone know how to look for over 60s using the DOB

iv looked through some other queries and cant understand them, so make it as
simple as possible please, many thanks!

 

[tina]

assuming your table has a date of birth field whose data type is Date/Time,
you could put the following criteria in a query, in the DOB field, as

< DateAdd("yyyy", -60, Date())

that will give you anybody who is age 60 or older, as of yesterday.

hth