Results 1 to 6 of 6
  1. #1
    rhewitt is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    74

    ORDER BY clause works in Query, but not in Report

    I have a Report that uses a query as it's record source. I have the query ordered by a field, which works as expected in the table view of the query. In the report, however, the ORDER BY clause does not seem to carry through. The field is not sorted Ascending.

    What's going on?

  2. #2
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    See here for how to sort on Access reports: http://blogs.office.com/b/microsoft-...n-reports.aspx
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  3. #3
    rhewitt is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    74
    Ahhhh, thanks.

    I assumed the sort would go through from the query.

    Is there any way to allow the user to define the sort field??

  4. #4
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Is there any way to allow the user to define the sort field??
    See here: http://www.databasedev.co.uk/sorting_reports.html
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  5. #5
    JoeM is offline VIP
    Windows XP Access 2007
    Join Date
    Jun 2012
    Posts
    3,904
    Another option to consider.
    If you want give people the ability to sort the data, you could export the query to an Excel file, where they can play around with it any way they like.
    Using Access 2007
    Proficient in Access, Excel, VBA, and SQL

  6. #6
    rhewitt is offline Advanced Beginner
    Windows 7 64bit Access 2010 64bit
    Join Date
    Sep 2012
    Posts
    74
    Excellent, thank you!

Please reply to this thread with any new information or opinions.

Similar Threads

  1. Replies: 4
    Last Post: 03-05-2012, 03:25 PM
  2. Order By Clause Issue
    By josh in forum Queries
    Replies: 5
    Last Post: 02-22-2012, 04:35 PM
  3. Printing report from first record works...
    By TinaCa in forum Programming
    Replies: 10
    Last Post: 01-17-2012, 10:59 AM
  4. Replies: 3
    Last Post: 01-15-2012, 02:46 PM
  5. Replies: 1
    Last Post: 07-17-2006, 06:30 AM

Tags for this Thread

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  
Other Forums: Microsoft Office Forums