Results 1 to 2 of 2
  1. #1
    tgwacker is offline Novice
    Windows 10 Access 2007
    Join Date
    Nov 2013
    Location
    Columbia, SC
    Posts
    9

    Report Not in Proper Sequence

    I am trying to create a report and the data is not coming out in the proper sequence. I have a table that has a field that places the entries into 1 of various categories. The user will select a category from a combo box that they want on their report. The data is then to be sorted into ascending order based on a description field. The report show the correct data for the selected category, but the records are not sorted by description. They appear in a random order.

    I have tried the following:
    - Had the report use a query with ascending on the description field.
    - Created a new table with only the fields to be reported. The description field is defined as the unique key field. After running the report, I looked at the contents of the table and it is in ascending order by the description field.
    It didn't matter because in both cases the data printed in a random order. Both reports had the records in the same order. The first letter of each description in the order printed is:
    S, B, B, C, G, I, O, R, S, S, S, A, S, Z, S, S, S, T, T, T, V, V, W, W, W, S


    None of the fields on the report would cause them to be sorted in the order in which they are appearing.

    I am using Access 2007

  2. #2
    aytee111 is offline Competent At Times
    Windows 10 Access 2013 64bit
    Join Date
    Nov 2011
    Location
    Nomad
    Posts
    3,936
    Use the Sorting & Grouping icon in the report design.

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

Similar Threads

  1. Proper Use of SetFocus?
    By rpeare in forum Forms
    Replies: 14
    Last Post: 10-21-2013, 02:58 PM
  2. Proper ERD
    By Zealotwraith in forum Access
    Replies: 1
    Last Post: 09-03-2013, 10:29 PM
  3. Replies: 3
    Last Post: 07-29-2012, 04:37 PM
  4. Help with proper where portion
    By tmcrouse in forum Queries
    Replies: 1
    Last Post: 10-11-2011, 03:25 PM
  5. Email with proper page orientation of Report
    By Robert M in forum Programming
    Replies: 1
    Last Post: 08-17-2009, 10:28 AM

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