Losing Sort Order

F

Fabrice

I've read the article "losing sort order in report".

I have in addition a note: I provided a report, which uses order by in the
recordsource. I am always assumed that that assortment and grouping delete
the order by instruction, however in this report the assortment likewise
deleted. What means it in addition?
 
D

Duane Hookom

I'm not quite sure I understand this question. However, I have found a
report's order is only reliably set within the Sorting and Grouping dialog.
I never expect a report to print in the same order as the report's
recordsource.
 
F

Fabrice

I see, I must give some explanation about my question:

I always assumed a sorting in "ORDER BY"-section of a Recordsource through
"Sorting and Grouping" one deletes, but if I do not indicate "sorting and
grouping" entries that then the "Order BY"-section it sorted the report
nevertheless.
Now I have a report, which does not follow this rule.

Did you unterstand now ? (My englich is not the best...)
 
D

Duane Hookom

I believe I understand. Apparently your value in the Order By property of a
report (with no sorting and grouping) has no affect on the actual printing
order.

Again, I suggest you always use the sorting and grouping. Check Allen
Browne's site for code on how to do this at run-time
http://members.iinet.net.au/~allenbrowne/ser-33.html.
 
Top