Sorting issue

[Guest]

I have a report, based on a query. The query is sorted by three fields, from
left to right in design view, the 3rd, 6th and 8th field (column). When I
run the query, the sort works as desired.
However, when I look at the data in the report, some of the data shows up
out of order. Is there any controls/properties that I should examine to
attempt to solve this problem.
It does appear that the data is OK, no unnecessary spaces, etc that could
throw off the sort order.
Please help.
Thanks
Paul

 

[Rick Brandt]

I have a report, based on a query. The query is sorted by three
fields, from left to right in design view, the 3rd, 6th and 8th field
(column). When I run the query, the sort works as desired.
However, when I look at the data in the report, some of the data
shows up out of order. Is there any controls/properties that I
should examine to attempt to solve this problem.
It does appear that the data is OK, no unnecessary spaces, etc that
could throw off the sort order.
Please help.
Thanks
Paul

Reports (for the most part) ignore the sorting of the underlying query. Use the
sorting and grouping dialog in the report's design instead.

 

[Guest]

Thanks. To easy.

Reports (for the most part) ignore the sorting of the underlying query. Use the
sorting and grouping dialog in the report's design instead.