[AccessD] Query tuning in Access?

Hi Erwin

One should leave the sorting to the report's Sorting and Grouping and
if possible avoid any sorting in the source.

And what is wrong with a saved query as source for a report? Many of
our reports uses quite complicated queries as source. It would be a mess
to pull that SQL into the recordsource of the reports.

/gustav

3) In a report, if SQL string based on saved querie, do not sort in
saved querie but only in SQL string of report.

Infact avoid reports based on saved queries, if you can.