Have worked for many years with the above both toegther and separately
(as in Jet and reports), I was always under the impression that the
order by clause of a query had no real bearing on the order of records
shown in a report based on the query. Sorting & grouping has to be
specified.
However, in A2003, I've been working on a large app for the past 6
months and have finally gotten around to creating and manuipulating
reports. I'm finding to my puzzlement that even without sorting and
grouping specified, the order of appearance of records on the reports
based on PTQs seems to be as one specifies in the PTQ.
IS this normal for PTQs? The Oracle SQL I'm generating is anywhere from
8 to 25 pages long (disgustingly monotonous union queries - it's a very
bad database design, though not my own) and it would really be lovely if
it was NOT necessary to parse through the various select clauses and
figure out what to plop into the sorting & grouping properties of a
report...
Thanks to anyone with any perspective on this.
--
Tim http://www.ucs.mun.ca/~tmarshal/
^o<
/#) "Burp-beep, burp-beep, burp-beep?" - Quaker Jake
/^^ "Whatcha doin?" - Ditto "TIM-MAY!!" - Me