Results 1 to 6 of 6
  1. #1
    Join Date
    Nov 2004
    Location
    West Of Atlanta
    Posts
    12

    Unanswered: Sorting A Report

    I have made great progress over the last two weeks. (Thanks Everyone)


    I am almost at a usable version of my work.

    I importing two tables froma flat file.
    I then Update Query both of them to modify the number fields to add a decimal to the amount fields.
    I then run another query based on relationships in the two tables.
    Finally I run a report based on the query.

    All is well. ALMOST.

    My report is not in Alphabetical order. I found out TODAY it must be.
    It needs to be sorted by the NAME of the person in the record.
    The name is ONLY found in one of my tables.
    The common

    All that I have tried has not changed my report.

    I tried sorting the tables and sorting the query. Nothing change the order of my report.

    HELP. I need some direction, please.

    Thanks in advance.

  2. #2
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Open your report in Design Mode, select Properties, and on the line that says Order By, put the name of the field from the query that the repport is based upon that contains the NAME of the person.

    TD

  3. #3
    Join Date
    Nov 2004
    Location
    West Of Atlanta
    Posts
    12
    TY

    Works Great


  4. #4
    Join Date
    Nov 2004
    Location
    West Of Atlanta
    Posts
    12
    Is there a way to do another sort on the same report?

    IE

    Sort by name
    then sort by date

    Thanks

  5. #5
    Join Date
    Sep 2004
    Location
    Charlotte, NC
    Posts
    164
    Sure. Open your report in Design Mode. Click the Sorting and Grouping icon on the toolbar (a large bracket with 2 smalller brackets to the right and then 2 lines to the right of each smaller bracket). In the Sorting and Grouping window pick the first field you want to sort on and select your sort order, then on the next line down select the next field that you want to sort on and select the sort order.

    TD

  6. #6
    Join Date
    Nov 2004
    Location
    West Of Atlanta
    Posts
    12
    Thank You!

    After playing with the settings in that area for a little while. I was able to make my report MUCH easier to read, and MUCH smaller.

    I was able to trim the report by almost 1/3 by not having it REPEAT information.

    Again, what a great forum here.

    God Bless,

    Paul

Posting Permissions

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