Results 1 to 7 of 7
  1. #1
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154

    Sorting issue in report

    Dear Guru



    I have a sorting problem in Report

    i want to sort the pairing no i need to group by hotel, then sort by check in date, then the paring

    Thanks in advance

    1.1
    1.2
    2.1
    2.2
    3.1
    3.2

    I Click image for larger version. 

Name:	sort.JPG 
Views:	19 
Size:	29.4 KB 
ID:	29838

  2. #2
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    So right click inside the report and go to Sorting and Grouping, add a group on the Hotal field and sorts on those fields you want sorted. Don't try to do it in the query of the report but in Sorting and Grouping.

  3. #3
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Bulzie


    I have a form with TABs and subforms. i found that i would not edit those subforms , is that any reasons?

  4. #4
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    Not sure what you are asking about the Tabs and subforms? The Original post was about sorting and grouping in a report. Did you get that issue resolved?

  5. #5
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Bulzie

    Sorry, there is another issue, may be i have to re post it

    the problem seems not really solved

    it is not real 1.1, 1,2 but 1.1 & 1.1 etc...

    Eric

  6. #6
    Bulzie is offline VIP
    Windows 7 64bit Access 2007
    Join Date
    Nov 2015
    Posts
    1,463
    So the sort on PAIRNO is not sorting correctly? If so it is probably a text field and not numeric. Maybe in the query on the form/repot try to use the Val function:

    vPAIRNO: Val([PAIRNO])
    and use vPAIRNO in your forms/report.

  7. #7
    Erictsang is offline Competent Performer
    Windows 10 Access 2016
    Join Date
    Jul 2017
    Posts
    154
    Thanks - Solved

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

Similar Threads

  1. Weird Sorting Issue
    By MattPGA in forum Access
    Replies: 6
    Last Post: 07-17-2017, 12:33 PM
  2. Sorting issue
    By Shawnf in forum Queries
    Replies: 1
    Last Post: 05-28-2016, 11:21 PM
  3. Data Sorting Issue
    By phd42122 in forum Access
    Replies: 5
    Last Post: 04-27-2012, 01:04 PM
  4. Report Sorting Issue
    By cbgroves in forum Reports
    Replies: 14
    Last Post: 12-01-2011, 08:44 AM
  5. Replies: 7
    Last Post: 07-10-2011, 06:55 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