Results 1 to 3 of 3
  1. #1
    Join Date
    Nov 2009
    Posts
    223

    Red face Unanswered: Report not following “Sort Descending’ request

    In my Query, I recently changed the Field which I wanted to ‘Sort’ (was sorted on Income ID, now sorted on Date Received).

    But the Report still sorts on Income ID (and ignores the new Sort request).

    Is this a bug in Access?
    What would you attempt to do if you knew you would not fail?

  2. #2
    Join Date
    Nov 2004
    Location
    out on a limb
    Posts
    13,692
    Provided Answers: 59
    set an explicit sort order inside the report
    I'd rather be riding on the Tiger 800 or the Norton

  3. #3
    Join Date
    Nov 2009
    Posts
    223
    Healdem,
    I have just ventured into unknown territory for me (I cannot do SQL coding).
    I managed to find the Report Property Sheet and inserted the name of the Field (Date Received) into the "Order By" section.
    Now it is sorting the correct field.
    Thanks for your guidance.
    What would you attempt to do if you knew you would not fail?

Posting Permissions

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