Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

Register Log in
  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Display sums for categories

Status
Not open for further replies.
docar

docar

Technical User
Nov 20, 2002
12
US
I have hundreds of records that have one of the 3 fee types and a dollar value:

Fee_TypeA
Fee_TypeB
Fee_TypeC

On a report I'd like to display the 3 types and total sum that I have for each type.

Thanks in advance.
 
Sort by date Sort by votes
Hi. What have you tried so far? What's not working?

Want to get great answers to your Tek-Tips questions? Have a look at FAQ219-2884 or FAQ222-2244
 
Upvote 0 Downvote
OK I got it. I created a query, Count the PK field, Group By the Fee_Type field, and Sum the Fee_Amount field.

 
Upvote 0 Downvote
Status
Not open for further replies.

Similar threads

breezett93
  • Locked
  • Question
Report often takes multiple minutes to load, lots of formatting time between pages
Replies
5
Views
252
dhookom
dhookom
FancyPrairie
  • Locked
  • Question
How to Format a date on a report
Replies
1
Views
161
sxschech
sxschech
PrimoSteve
  • Locked
  • Question
Print Report from a Subform (Tab form) in a Main Form
Replies
1
Views
100
dhookom
dhookom
BallunarCrew
  • Locked
  • Question
Report Header and Column Formatting Issue 1
Replies
2
Views
280
BallunarCrew
BallunarCrew
PLCBeetle
  • Locked
  • Question
Pass Form value to Report Record Source
Replies
4
Views
118
dhookom
dhookom

Part and Inventory Search

Sponsor

Back
Top