Results 1 to 8 of 8
  1. #1
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    202
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Question Sorting a report based on a date field

    I have a report based on a query in Access 2010. The query/report has several date fields. After I produce my report, I convert it to PDF. I want to have the final report/PDF records sorted by one of the date fields. How can I do this? Thanks.
    JimmyW
    Helena, MT

  2. #2
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,407
    Thanks
    208
    Thanked 833 Times in 766 Posts
    Jimmy,

    The easiest way I know is to make the query sort by that date field. HTH
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  3. #3
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,537
    Thanks
    0
    Thanked 23 Times in 23 Posts
    Or if it's a report you are creating the PDF from, then change the sorting in the report, you can't do it via the query that the report is based upon.

  4. #4
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,407
    Thanks
    208
    Thanked 833 Times in 766 Posts
    Quote Originally Posted by patt View Post
    Or if it's a report you are creating the PDF from, then change the sorting in the report, you can't do it via the query that the report is based upon.
    Patt,

    Did you leave out an IF?
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  5. #5
    3 Star Lounger Jimmy-W's Avatar
    Join Date
    Jan 2001
    Location
    Helena, Montana, USA
    Posts
    202
    Thanks
    10
    Thanked 0 Times in 0 Posts
    Thanks! Sorting the query didn't work, but I added a date header to my report and sorted that way. Then, the PDF picks up the Access report in that order.
    JimmyW
    Helena, MT

  6. #6
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,537
    Thanks
    0
    Thanked 23 Times in 23 Posts
    Retired Geek, Where?

  7. #7
    Super Moderator RetiredGeek's Avatar
    Join Date
    Mar 2004
    Location
    Manning, South Carolina
    Posts
    6,407
    Thanks
    208
    Thanked 833 Times in 766 Posts
    See red.
    Quote Originally Posted by patt View Post
    Or if it's a report you are creating the PDF from, then change the sorting in the report, if you can't do it via the query that the report is based upon.
    I'm assuming you did since I've successfully sorted queries and the results show on the report. Of course this is assuming you haven't made changes at the report level that changes that setting.
    May the Forces of good computing be with you!

    RG

    VBA Rules!

    My Systems: Desktop Specs
    Laptop Specs


  8. #8
    Platinum Lounger
    Join Date
    Dec 2001
    Location
    Melbourne, Australia
    Posts
    4,537
    Thanks
    0
    Thanked 23 Times in 23 Posts
    How about that, I have tried that in the past and it never seemed to work.

Posting Permissions

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