UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome Guest ( Log In | Register )

 
 Reply to this topicStart new topic
> SUm of one field based on another    
 
   
bmahony993
post Oct 18 2006, 12:11 PM
Post #1

UtterAccess Addict
Posts: 208
I have a report based on donations. The amount is listed, and the type of donation is listed. I would like to get the total amounts based on the type of donation. I have a text box currently with =sum(amt) which gives me the totals for everything, but I just cannot think of how to get it for each type of donation...
Thanks in advance
Go to the top of the page
 
+
fkegley
post Oct 18 2006, 12:54 PM
Post #2

UtterAccess VIP
Posts: 23,583
From: Mississippi
Open the report in Design View. Click View--->Sorting and Grouping... Put the field you want to group on in the first row of the box that appears. Set Group Footer to Yes.

Copy the text box that is already giving you the overall total and paste it into the Group Footer. You'll need to locate it AFTER you paste it.
Go to the top of the page
 
+
bmahony993
post Oct 18 2006, 01:02 PM
Post #3

UtterAccess Addict
Posts: 208
Thanks!
Go to the top of the page
 
+
fkegley
post Oct 18 2006, 01:12 PM
Post #4

UtterAccess VIP
Posts: 23,583
From: Mississippi
You're welcome. I am glad I could help.
Go to the top of the page
 
+
« Next Oldest · Access Reports · Next Newest »
 

Thank you for your support! Reply to this topicStart new topic

Jump To Forum:
 

Display Mode: Standard · Switch to: Linear+ · Switch to: Outline

Track this topic · Email this topic · Print this topic · Subscribe to this forum

RSS Go to Top  ·  Lo-Fi Version Time is now: 18th May 2013 - 08:32 AM