Sorting in reports (Access 2000)

Topic

New Reply

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

Reply | Quote

Replies

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.

Reply | Quote

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

Dorothy

Reply | Quote

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

Dorothy

Reply | Quote

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.

Reply | Quote