P
patti
I have a query that sorts correctly on ClientNo field.
Report based on that query has different sort; why would this be?
Report based on that query has different sort; why would this be?
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
P
patti
I created a new report based on the query and that report was fine. So why
does the original report not work?
Access 2003.
does the original report not work?
Access 2003.
D
Duane Hookom
It sounds like you are expected a report to honor the sorting of a query.
Don't. If you want records in a report sorted, use the report's sorting and
grouping dialog.
Don't. If you want records in a report sorted, use the report's sorting and
grouping dialog.
A
Allen Browne
In report design view, use the Sorting And Grouping pane to specify how you
want the report sorted.
This is much more reliable than hoping the report will sort as the query
does. In general, there's no point sorting the source query for a report.
want the report sorted.
This is much more reliable than hoping the report will sort as the query
does. In general, there's no point sorting the source query for a report.
P
patti
Thanks Duane and Allen.
Allen Browne said:In report design view, use the Sorting And Grouping pane to specify how you
want the report sorted.
This is much more reliable than hoping the report will sort as the query
does. In general, there's no point sorting the source query for a report.
--
Allen Browne - Microsoft MVP. Perth, Western Australia
Reply to group, rather than allenbrowne at mvps dot org.
.