sort by sum of a field

Discussion in 'Microsoft Access Reports' started by Darrell Eddy, Apr 14, 2010.

  1. Darrell Eddy

    Darrell Eddy Guest

    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
     
    Darrell Eddy, Apr 14, 2010
    #1
    1. Advertisements

  2. Darrell Eddy

    KARL DEWEY Guest

    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
    >
    >
    > .
    >
     
    KARL DEWEY, Apr 14, 2010
    #2
    1. Advertisements

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

It takes just 2 minutes to sign up (and it's free!). Just click the sign up button to choose a username and then you can ask your own questions on the forum.
Similar Threads
  1. Martin

    Field on report bound on sum field of sub report

    Martin, May 17, 2004, in forum: Microsoft Access Reports
    Replies:
    2
    Views:
    184
    Marshall Barton
    May 17, 2004
  2. gumby

    =Sum(Abs([field]="Value")*[Field]

    gumby, Jul 26, 2006, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    333
    Duane Hookom
    Jul 26, 2006
  3. Guest

    Sum of one field based on date in another field

    Guest, Feb 20, 2007, in forum: Microsoft Access Reports
    Replies:
    1
    Views:
    246
    Guest
    Feb 20, 2007
  4. Robert G. Flade, RN, MS

    Sum one field if another field is equal to something

    Robert G. Flade, RN, MS, Jul 20, 2009, in forum: Microsoft Access Reports
    Replies:
    10
    Views:
    2,623
    mattsmom
    Aug 4, 2009
  5. Repent
    Replies:
    8
    Views:
    455
    John Spencer
    Nov 6, 2009
Loading...

Share This Page