how to do calculations in access queries?

[PaulE]

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?

 

[John Vinson]

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?

Not knowing anything about how your tables are structured, nor the SQL
of your query, I have no clue. Care to give us some help here?

Please describe the tables, and open the query in SQL view and post
the SQL text here.

John W. Vinson[MVP]