sort by sum of a field

D

Darrell Eddy

I have a table with several thousand records with the following fields:

username, job, total pages

What I want to do is group the records by username, then count the total of
all grouped records of the total pages field to get a sum. Then I need to
sort the results of the total of the "total pages field in decending order.
I got a report to show me the summary of the user name and jobs, and to show
the total from the totalpages, but how do you sort the report on the total
pages by decending order?

Darrell Eddy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

sort report results by a custom field 1
trying to sum a group of records but "sum" missing from Group, Sort, and Total dropdown/wizard 8
A03 - count in report footer gives me #Error? 0
How do I sort by calculated field 1
Access Dcount (multiple criteria) 3
using "yes/no" field to sort report data and create subtotals & to 9
Sort by value, not alpha 2
Report to calculate total spent by customers in a customer db 8

Top