Help needed with date query!

[melvis]

Hi all,

I've searched the forums but can't seem to find anything similar. I work for social services and we have a database that stores information on children who may need services from adults when they reach 18.

What I need to do is create a query (so that a report can be run) that will show those children who will turn 18 during the year Apr 1st - Mar 31st but I'm not sure where to start. Can anyone offer any pointers please?

The fields within the database are:
Client ID, Name, Surname, Date of Birth, Address

Many thanks

 

[Brianwarnock]

A simple approach would be to use DateAdd to add 18 years to the DOB and see if that date falls between the dates you are interesred in , perhaps picking those up from a form that drives the query.

Date18: DateAdd("yyyy",18,[DOB])

criteria between....,.And....


Brian

 

[melvis]

Hi Brian,
Thanks for the response, it keeps asking me for a parameter though. Any other suggestions?

Cheers

 

[Brianwarnock]

What did you actually code, it sounds as though you may have a typo in the code, probably a field name and thus it acts like a parameter query.

Brian