Ok, I have a query which ought to be pretty simple.  Here goes.

I'm a rusty intermediate user of Access who is having to get back in to it in a new job, the question is in reference to Access 2000.

I have two extensive tables I'm trying to filter in a query to show me only those groupings that were:

A: Born after a certain date (using the Parent Date Of Birth field), and;

B: Have a child, born whilst the client was still a teenager. (using child DOB field).

Hence the challenge is to get, based on the two DOB fields, any data where the age between the parent and child is less than 20 years (even if both parties are now well past their teenage years!).  How can I set up criteria to do this?

If I dumped the data into Excel I could probably do it, but that is not a solution in the long term.

Thanks in advance for any wisdom you can offer!

Dean

---

Answer from Richard Rost:

Assuming both your parent and child are listed in the same RECORD (parentDOB and childDOB) then you could just create a new calculated field in a query to show you the difference between those two dates.

Here's a tutorial that explains how to do that:

http://599cd.com/tips/access/dates-datediff-dateadd/?key=BlFAlEx