Date Query

[melvis]

Hello all,

I've been asked to set up a basic database to store information on clients that will need to receive a service from us when they reach 18 years old. I have set up the table but am not sure on how to write the query.

I need the query to create a report that will list all of the clients who will be 18 in 6 months time. Has anybody got any ideas as to where I am to start?

Also, can this report be run every month and saved as a new report in the database window?

Many thanks

 

[FoFa]

how about in your criteria
DATEDIFF("m",Date(),[Birthdate]) = 210

18 years = 216 months, so 210 is 18 years minus 6 months.