Results 1 to 4 of 4
  1. #1
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Access 2003 Report: Sorting Problem

    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...
    Attached Images Attached Images

  2. #2
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    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.
    Regards
    John



  3. #3
    2 Star Lounger
    Join Date
    Sep 2002
    Posts
    180
    Thanks
    0
    Thanked 0 Times in 0 Posts
    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

  4. #4
    Super Moderator
    Join Date
    Jun 2002
    Location
    Mt Macedon, Victoria, Australia
    Posts
    3,993
    Thanks
    1
    Thanked 45 Times in 44 Posts
    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.
    Regards
    John



Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •