Results 1 to 3 of 3
  1. #1
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Sorting in reports (Access 2000)

    I think this may be a question that has a simple answer. I have a report that sorts by company Ascending. There is a category called Unclaim that the client would like to go at the end of the list of companies rather than mixed up within the companies. Is there a way to take something out of ascending order and place it at the bottom of the list, or for that matter, at the top of a list?

    Thanks
    Dorothy

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Sorting in reports (Access 2000)

    Open the report in design view.
    In the Sorting and Grouping window, click in the first empty row.
    In the Field/Expression column, enter this expression

    =[Company]="Unclaim"

    where Company is the name of the field.
    Select this row as a whole and drag it to above the row that specified sorting by Company.
    By sorting ascending or descending on the expression, you can place "Unclaim" at the top or bottom of the sort order.

  3. #3
    Star Lounger
    Join Date
    Mar 2001
    Posts
    56
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Sorting in reports (Access 2000)

    Thank you Hans. You have been an incredible help. Off to sunny Florida. Take care.

    Dorothy

Posting Permissions

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