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