Sorting issue

[PA]

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

 

[PA]

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.