Sorting report by grand total from report footer

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Soboths - 23 Mar 2007 23:10 GMT

I have a report that listed and sorted by Product Category ID, Product#, and
$Sale by each product. At the product Category ID footer, I also have a
SumOf$Sale by Product Category ID. I would like to have my report sort by the
SumOf$Sale, which is the result of each product category ID from product
category footer in descendent but still keep together with its product
category ID. Is there a way to do this?

Thanks for any help in advance.

Reply to this Message

Marshall Barton - 24 Mar 2007 00:53 GMT

>I have a report that listed and sorted by Product Category ID, Product#, and
>$Sale by each product. At the product Category ID footer, I also have a
>SumOf$Sale by Product Category ID. I would like to have my report sort by the
>SumOf$Sale, which is the result of each product category ID from product
>category footer in descendent but still keep together with its product
>category ID. Is there a way to do this?

Yes, but there is no way to sort a report by a value that is
calculated within the report. You need to calculate the sum
in the report's record source query.

Signature

Marsh
MVP [MS Access]

Reply to this Message

Soboths - 28 Mar 2007 00:14 GMT

Thanks for your help Marsh.

> >I have a report that listed and sorted by Product Category ID, Product#, and
> >$Sale by each product. At the product Category ID footer, I also have a
[quoted text clipped - 6 lines]
> calculated within the report. You need to calculate the sum
> in the report's record source query.

Reply to this Message