So this might belong in the queries section, as the answer may be, how to create a single query with all this information.
and it would take a small novel to explain why the data is setup this way but just accept that it has to be the way it is.
one query pulls data from a table about past due fees, and fines for each chapter in our organization.
another query pulls data from a different table about loans that any chapter has taken out from the organization.
how can I get all of this data on a single report.
the pictures below should help explain better what I am trying to do.
Thanks for any help