Need Help with Totaling


C

CRBI

I'm not even sure how to explain this. I have a membership database in which
I've created a form for the member's basic data-name, address, phone, etc.
Within that form is a subform that shows where they have made donations, how
much, the date of the donation, and if it were for anything specific---could
be simple membership, end of year donation, river revelry
participation.....various things. I have to create annual reports showing how
much money we have taken in this year in membership donations. I have already
writtent the query to pull this and created the report. Here's my problem:
Some members may have contributed more than once over the course of the year.
When the query (and subsequent) report pulls my data, it is going to show
more than one entry for a person who has. My boss wants me to have the
query/report show a total of the member's contributions, rather than each
contribution. I could probably spend some time figuring this out on my own,
but since I have a tight deadline I thought I might ask if anyone knows a
fairly simple way I could do this. Any help is appreciated!
 
Ad

Advertisements

S

Steve

A Totals query would be a simple way to do this. Create a query that shows
each member and each of his donations. Click on the Sigma button (looks like
a capital E) at the top of the screen. Under the member field, change Group
By to Sum.

Steve
(e-mail address removed)
 
Ad

Advertisements

S

Steve

oops!!

Under the donation field, change Group By to Sum. Leave Group By under the
Member field.

Steve
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top