Coordinating the sort order in a report with the underlying query

Tech-Archive recommends: Fix windows errors by optimizing your registry

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


.

Relevant Pages

  • RE: HOW CAN I SORT SEQUENTIALY IN A REPORT?
    ... Create a new table in design view with three ... report in Print Preview. ... sorting is not really an option. ... >> The query displays data in the order you need? ...
    (microsoft.public.access.reports)
  • Re: "Enter param values" for deleted controls
    ... right in the Sorting and Grouping box. ... > Open the report in design view. ... > Also check the Properties of the report: ... rather than allenbrowne at mvps dot org. ...
    (microsoft.public.access.reports)
  • Re: Report does not alphabetize from Table
    ... Open the report in design view, and choose View> Sorting & Grouping ... to be discussed in any entry-level Access book. ...
    (microsoft.public.access.tablesdbdesign)
  • Re: Record sorting and report total conflicting!
    ... even if you leave the group expression blank for each level in the report itself it seems to work just fine to modify the control source from VBA code. ... >> I then tried the following instead, but you have to be in report design ... >> You need to set the sorting and grouping levels in the report. ...
    (microsoft.public.access.reports)
  • Re: ISE software bug???
    ... The design & report files attached below. ... TIMING REPORT ... Add Generic Clock Buffer: 8 ...
    (comp.arch.fpga)