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!

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

How to sort report on a summary?

Status
Not open for further replies.

hutchinsm

Technical User
May 7, 2002
3
US
I'm working on a report that shows the purchases of buyers within my company. This particular report shows the purchase details of the top spenders and then sums the individual charges for each buyer. The Name of each buyer is being used as a header for their corresponding transactional detail. Is there a way to keep the header as is and sort the "sum" of each buyer's detail descending?
 
Hi!

Yes you can, but you will need to include the sum in the query you base the report on.

hth
Jeff Bridgham
bridgham@purdue.edu
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top