Results 1 to 3 of 3
  1. #1
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919

    Sort order of RecordSource not working

    I have a query that includes the following:
    Click image for larger version. 

Name:	000.jpg 
Views:	9 
Size:	32.0 KB 
ID:	46413
    The query displays perfectly sorted, according to the value returned with "SortFld", when opened in design view, ("!"), but not when the query is used as the RecordSource of my report. Along with the others, there is a text box in the detail section bound to "SortFld" and it displays as one would expect. But again, the sort order of the report does not correspond to the "SortFld" expression in the query.



    Is there something inherently wrong with the use of such an expression as I'm using it?

    (snip sample of open query)
    Click image for larger version. 

Name:	001.jpg 
Views:	9 
Size:	43.5 KB 
ID:	46414

  2. #2
    June7's Avatar
    June7 is online now VIP
    Windows 10 Access 2010 32bit
    Join Date
    May 2011
    Location
    The Great Land
    Posts
    52,816
    Report Sorting & Grouping design takes precedence. If there is ANY Sorting & Grouping set in report design, the query sort will be ignored, as well as OrderBy property.
    How to attach file: http://www.accessforums.net/showthread.php?t=70301 To provide db: copy, remove confidential data, run compact & repair, zip w/Windows Compression.

  3. #3
    GraeagleBill's Avatar
    GraeagleBill is offline Experienced Old Geezer
    Windows 10 Access 2013 32bit
    Join Date
    Feb 2011
    Posts
    1,919
    Sorting & Grouping design takes precedence
    Thanks June7, that was the problem. (Must have been left over from an old copy/paste)

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

Similar Threads

  1. ORDER BY sort order?
    By TOPSie in forum Queries
    Replies: 4
    Last Post: 04-23-2021, 03:25 AM
  2. Replies: 5
    Last Post: 08-27-2019, 08:41 AM
  3. Replies: 13
    Last Post: 11-12-2017, 01:27 AM
  4. Sort Order problem
    By Chris@harveynorman in forum Reports
    Replies: 8
    Last Post: 11-22-2016, 10:42 PM
  5. Replies: 3
    Last Post: 08-28-2011, 08:24 PM

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