MS Access – TOUGH ONE

I have a Parent Table with Names & Addresses. I also have a child table with Yearly Dues information. The child table has the year and an activity field (Active/Inactive).

For each year I enter the year and whether the person was active or inactive. Some people do not have any entry for every year!

I need a query which will find those Members who have EVERY CHILD record marked as INACTIVE.

For Example:
Member: Joe
2004 Active 2003 Inactive 2002 Active (Don’t Choose this one)

Member: Sue
2004 Inactive 2003 Inactive 2002 Inactive (Choose this one)

Member: Rocky
2004 Inactive 2003 Inactive NO 2002 Record (Choose this one)

Member: Fred
2004 Active 2003 Active NO 2002 Record (Don’t Choose this One)

I realize this is a really tough Query but I’m hoping that someone out there can help me….

Thanks,
Alan
NYC