Sorting issue

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
PA said:
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
Click to expand...

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

Rick Brandt said:
Reports (for the most part) ignore the sorting of the underlying query. Use the
sorting and grouping dialog in the report's design instead.
Click to expand...
 
Back
Top