I have an Access 97 Application. The Parent records contain names, addresses & ID number.
The Child records contain the ID dumber, Dues year, and Dues amount paid.
I want to produce a report with one line for each member.
Only those who have NOT PAID their 2002 year dues should be shown.
For each non-paying (2002) member I want his/her name and the amount he/she paid in Year 2001 (if any).
Anybody have any idea of how to do this????
Any help you can give would be ghreatly appreciated!!!!
Alan
