Gustav Brock
Gustav at cactus.dk
Thu Feb 24 03:19:28 CST 2005
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.