Hi All,

Need a little help. I have a queery that displays all the fields of a database where the email address is not null what i also want the queery to do is only display all the fields where the date is newer than.

For example i have a field in the database called DOB (date of birth) but i only want to displays all the info from a specific date ie 15/05/1982 which would display everyone 20 years or older.

Any ideas how to acheive this?

Add a column to the query and put this in the field- Age: DateDiff("yyyy",[DOB],Now())+Int(Format(Now(),"mmdd")<Format([DOB],"mmdd"))

In the Criteria line put >=20

Hi Jack.

Thats great!! I added >19 to the criteria and it displays everyone who is 20 and over is this correct?

If i put <20 it displays everyone under 20?