Order of Report Changes

[Guest]

I have a simple question. I have a simple report that is ordered by a query.
If I don't use the a textbox with the value= Count(*) everything is find. If
use it the order is changed! How can I use the =Count(*) and keep the order
from the query?

Thanks,

 

[fredg]

I have a simple question. I have a simple report that is ordered by a query.
If I don't use the a textbox with the value= Count(*) everything is find. If
use it the order is changed! How can I use the =Count(*) and keep the order
from the query?

Thanks,

The sort order of the query is irrelevant to the sort order of the
report.
Sort the report using the Report's Sorting and Grouping dialog.
In Report Design View:
View + Sorting and Grouping