Prev: Report Detail section coding
Next: Using the "Select Case..." function
From: Darrell Eddy on 14 Apr 2010 12:22
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


From: KARL DEWEY on 14 Apr 2010 14:20
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
>
>
> .
>
 | 
Pages: 1
Prev: Report Detail section coding
Next: Using the "Select Case..." function