Coordinating the sort order in a report with the underlying query

I've noticed that you can sort records on any field in a report by adding
that field to the Sorting and Grouping dialog box in Report Design View.
Does this override the sort order designated in an underlying query?

I'd like to follow best practices for designing a report, and so I'm
wondering if it's better to use the query to sort records, and just use the
Sorting and Grouping dialog to establish grouping levels.

I'd appreciate any suggestions in this regard.

Thanks in advance,

Paul

Yes: the Sortin'n'Grouping in the report defines its sort order. You may as
well just omit any sorting in its source query.

It is possible to programmatically set the ControlSource of the GroupLevel
when you open the report. This article explains how:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Paul" wrote in message
...
I've noticed that you can sort records on any field in a report by adding
that field to the Sorting and Grouping dialog box in Report Design View.
Does this override the sort order designated in an underlying query?

I'd like to follow best practices for designing a report, and so I'm
wondering if it's better to use the query to sort records, and just use
the Sorting and Grouping dialog to establish grouping levels.

What a great way to give my users control over the sorting of a report.

Thanks (again), Allen.

Paul


"Allen Browne" wrote in message
...
Yes: the Sortin'n'Grouping in the report defines its sort order. You may
as well just omit any sorting in its source query.

It is possible to programmatically set the ControlSource of the GroupLevel
when you open the report. This article explains how:
Sorting report records at runtime
at:
http://allenbrowne.com/ser-33.html

--
Allen Browne - Microsoft MVP. Perth, Western Australia
Tips for Access users - http://allenbrowne.com/tips.html
Reply to group, rather than allenbrowne at mvps dot org.


"Paul" wrote in message
...
I've noticed that you can sort records on any field in a report by adding
that field to the Sorting and Grouping dialog box in Report Design View.
Does this override the sort order designated in an underlying query?

I'd like to follow best practices for designing a report, and so I'm
wondering if it's better to use the query to sort records, and just use
the Sorting and Grouping dialog to establish grouping levels.