Discussion Locked

Access 97 Report w/Child Records

0 helpful
3 replies
Closed to new repliesThis discussion is closed. It stays readable, but it takes no new replies.

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

3 replies

by r. a. caluste

Hmmm...

You can try this queries:

qryMy2001
SELECT * from parenttable inner join childtable on parenttable.id = childtable.id where year = 2001

qryNotMy2002
SELECT * from parenttable inner join childtable on parenttable.id = childtable.id where year <> 2002

qryMain
SELECT * from qryMy2001 where id in (select * from qryNotMy2002)

'queries those who paid in 2001 for all id who did not pay in 2002.

put these query in your report and use the aggregate textboxes to sum the amount.

hope this helps.

This discussion is closed to new replies.