Ascending order

[Guest]

Hey guys,

I've created a report based off one of my queries, put in all of my hardwork
into it and sorted "ascending" vs. "descending". Is there a way to remedy
this without starting all the way over from the beginning?

Andre Adams

 

[RBear3]

Sure, just open your grouping and sorting box and change it.

 

[John W. Vinson]

Hey guys,

I've created a report based off one of my queries, put in all of my hardwork
into it and sorted "ascending" vs. "descending". Is there a way to remedy
this without starting all the way over from the beginning?

Yes, pretty simply at that!

Reports *COMPLETELY IGNORE* any sort order defined in their recordsource.

What you need to do is right mouseclick the little square at the upper left
intersection of the rulers, in design mode; and choose "Sorting and Grouping".

Specify your sort order in that dialog box and save the report.

John W. Vinson [MVP]

 

[Douglas J. Steele]

Just to expand on that answer a little bit.

Reports do not respect any sorting done on the query that makes up their
recordsource. Any desired sorting in a report must be done using the Sorting
and Grouping dialog. (You can change it programmatically, though, if you
need to. See http://www.allenbrowne.com/ser-33.html for an approach)