Sort in Descending order

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Graham - 26 Oct 2005 15:12 GMT

I have a report which totals transactions then only displays the totals in
the report. How can I sort these totals in decending value order.

Thanks
Graham

Reply to this Message

Duane Hookom - 26 Oct 2005 15:55 GMT

You can't without adding the totals into the report's record source query.
You can create a new totals query similar to your report's record source
only view the totals and group by whatever and total whatever. Join this
totals query to your report's record source query and use the totaled field
as your sorting expression.

Signature

Duane Hookom
MS Access MVP

>I have a report which totals transactions then only displays the totals in
> the report. How can I sort these totals in decending value order.
>
> Thanks
> Graham

Reply to this Message

Ofer - 26 Oct 2005 15:58 GMT

As much as I know, you can't.
You can sort the report only with fields that are part of the report record
source.

Signature

If I answered your question, please mark it as an answer. That way, it will
stay saved for a longer time, so other can benifit from it.

Good luck

> I have a report which totals transactions then only displays the totals in
> the report. How can I sort these totals in decending value order.
>
> Thanks
> Graham

Reply to this Message