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. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
sort by sum of a field
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 |
#2
|
|||
|
|||
sort by sum of a field
Use the report Sorting and Grouping.
-- Build a little, test a little. "Darrell Eddy" wrote: 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 . |
Thread Tools | |
Display Modes | |
|
|