Ascending order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Andre Adams - 30 May 2007 17:57 GMT

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

Reply to this Message

RBear3 - 30 May 2007 18:10 GMT

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

Signature

Hope that helps!

RBear3
.

> Hey guys,
>
[quoted text clipped - 4 lines]
>
> Andre Adams

Reply to this Message

Douglas J. Steele - 30 May 2007 18:43 GMT

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)

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> Sure, just open your grouping and sorting box and change it.
>
[quoted text clipped - 7 lines]
>>
>> Andre Adams

Reply to this Message

John W. Vinson - 30 May 2007 18:38 GMT

>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]

Reply to this Message