Report stating memberss with no entry in a related table

[dougkluth]

Hello,



I am writing a membership database. I have a main table that contains relevant information about the member. It has an autonumber field called entrynumber that is linked to another table called financial. It also has the entrynumber field in a one to many relationship. The financial table lists any monies paid into the club. Most entries will be dues, but there could be donations, upkeep, etc. In the first table I also have a field that lists the members status, active or terminated. I need to write a report that lists any member who is active and does not have entry in the financial table listed "dues". This report/query needs to also have a parameter query for specifying dates. Having a hell of a time with this one. Any examples or help would be greatly appreciated.

Thanks,

Doug

[orange]

Suggest you try using the query wizard to create a query to get the info you want from the tables, then use that as the source for your report.
It's possible your table/relationships d not support what you are trying to do.

This data model may give you some ideas.
http://www.databaseanswers.org/data_...bers/index.htm