• Access 2003 Report: Sorting Problem

    Home » Forums » AskWoody support » Productivity software by function » MS Access and database help » Access 2003 Report: Sorting Problem

    Author
    Topic
    WSc1fer
    AskWoody Lounger
    March 11, 2011 at 6:48 pm #475382

    I have a Sales report.

    It is sorted right now by Sales Rep
    The Details includes Items sold and the points given for that sale.
    The footer shows the subtotal for that Sales rep.

    For some reason I cannot sort it by the total amount of Points so I can list the top seller first.

    I have included screen shots

    Can I get some assistance please…

    Reply | Quote
    Viewing 1 reply thread
    Author
    Replies
    • WSjohnhutchison
      AskWoody Lounger
      March 11, 2011 at 7:38 pm #1271399

      You can only sort by fields in the underlying query, so if the total points is calculated within the report it is not available for sorting.

      Reply | Quote
      • WSc1fer
        AskWoody Lounger
        March 12, 2011 at 4:44 pm #1271473

        Thats what I thought. I think I may have asked this question before.

        I guess I’ll do the old Access trick. Create a Make-Table macro for the results and then base the report on that.

        Thanks again

        Reply | Quote
    • WSjohnhutchison
      AskWoody Lounger
      March 12, 2011 at 5:03 pm #1271475

      You don’t need a MakeTable query, although that is an option. Use a totals query to calculate the total, then join that query to the query used for the report.

      Reply | Quote
    Viewing 1 reply thread
    Reply To: Access 2003 Report: Sorting Problem

    You can use BBCodes to format your content.
    Your account can't use all available BBCodes, they will be stripped before saving.

    Your information:




DON'T MISS OUT!
Subscribe to the Free Newsletter
We promise not to spam you. Unsubscribe at any time.
Invalid email address

View the Forum

  • Recent Replies
  • My Replies
  • My Active Topics
  • New Posts in the Last day
  • Private Messages
  • Knowledge Base
  • How to use the Forums
  • All Forums

    • Recent Topics

    My Profile

    April 2025
    S M T W T F S
     12345
    6789101112
    13141516171819
    20212223242526
    27282930  

    Remembering Woody

     

    Want to Advertise in the free newsletter? How about a gift subscription in honor of a birthday? Send an email to sb@askwoody.com to ask how.

    Mastodon profile for DefConPatch
    Mastodon profile for AskWoody

     

    Home • About • FAQ • Posts & Privacy • Forums • My Account
    Register • Free Newsletter • Plus Membership • Gift Certificates • MS-DEFCON Alerts

    Copyright ©2004-2025 by AskWoody Tech LLC. All Rights Reserved.