If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Need Help with Totaling
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! |
Thread Tools | |
Display Modes | |
|
|