Report showing data differently

[Drew]

I have a query that I changed the ORDER BY to something else, but now the
report won't change. It still displays the same data in the same order. I
made sure that the Order By in the Report Properties was not being used, Is
there anything that I might have missed?

Thanks,
Drew

 

[Allen Browne]

You cannot reliably sort a report by setting the ORDER BY property of its
RecordSource.

Instead, use the report's Sorting'n'Grouping box to specify the sort order.

You can do this at runtime if necessary. Details:
http://members.iinet.net.au/~allenbrowne/ser-33.html

 

[Drew]

Thanks a bunch for this info, I was perplexed on how this was being sorted,
I found and fixed the problem thanks to you!

Thanks,
Drew