What expression do I put in my query access ?

Question

for all people who are for example 3 years old or who are supposed to have an injection done at the age of 6 years?

Answer 1

Presuming you have a date of birth field in date format, as an example to find those 3 or younger the criterion under the d.o.b. would be "<27/02/04" without the quotes & for use today.

Hope that helps.