My output is a report that calculates currency for different events (Mission,
Bibleband, offering, brohood, sishood, etc) and then adds the total of all
the events based on members who paid.  I have a query that pulls members that
paid based a on a YES/NO field, a query that then sums the values paid by
those individuals, and a final query that totals the sum of all the members.  
This works fine for a weekly report, but when I try to do the same thing for
a yearly report for a certain individual or group of indiduals, it totals
every record and not just the records that appear in the query results.  What
I'm I missing?