A Microsoft Office (Excel, Word) forum. OfficeFrustration

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.

Go Back   Home » OfficeFrustration forum » Microsoft Access » Database Design
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Need Help with Totaling



 
 
Thread Tools Display Modes
  #1  
Old January 7th, 2010, 07:26 PM posted to microsoft.public.access.tablesdbdesign
CRBI
external usenet poster
 
Posts: 16
Default 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!
Ads
  #2  
Old January 7th, 2010, 07:48 PM posted to microsoft.public.access.tablesdbdesign
BruceM via AccessMonster.com
external usenet poster
 
Posts: 448
Default Need Help with Totaling

You should be able to do this with a Totals query. In the query design grid,
create a query with the Contribution and MemberID fields. Click the sideways
M on the toolbar (I forget the name of the symbol). This should add a Total
row to the design grid. Select Group By for MemberID, and Sum for
Contirbution. You may be able to add other fields such as FirstName or
LastName (choose Group By for the added fields, but be sure the number of
records does not change from when you used just MemberID and Contribution).

CRBI wrote:
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!


--
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/For...esign/201001/1

  #3  
Old January 7th, 2010, 07:55 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Need Help with Totaling

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



"CRBI" wrote in message
...
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!



  #4  
Old January 7th, 2010, 09:36 PM posted to microsoft.public.access.tablesdbdesign
Steve[_77_]
external usenet poster
 
Posts: 1,017
Default Need Help with Totaling

oops!!

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

Steve

"Steve" wrote in message
...
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



"CRBI" wrote in message
...
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

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 07:37 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2020, Jelsoft Enterprises Ltd.
Copyright 2004-2020 OfficeFrustration.
The comments are property of their posters.