Group on results of calculated value

My recordsource returns currency amounts per client per project. In the
report I show the amounts per project then show the sum of the amounts per
client in the client group footer.

How would I group these summed amounts in descending order in the report?

regards

Terry

Create a second summing query with the projectID and sum
on amount to ProjectTotal, and a third for the ClientID
and sum on amount to Client Total.
Now merge the three queries by clientID and ProjectID and
include the ClientTotal and ProjectTotal.
Now you can do whatever sorting and grouping you wish.
Hope this helps
Fons
-----Original Message-----
My recordsource returns currency amounts per client per
project. In the
report I show the amounts per project then show the sum
of the amounts per
client in the client group footer.

How would I group these summed amounts in descending
order in the report?

regards

Terry


.

Thanks Fons,
All done OK.
Regards

"Fons Ponsioen" wrote in message
...
Create a second summing query with the projectID and sum
on amount to ProjectTotal, and a third for the ClientID
and sum on amount to Client Total.
Now merge the three queries by clientID and ProjectID and
include the ClientTotal and ProjectTotal.
Now you can do whatever sorting and grouping you wish.
Hope this helps
Fons
-----Original Message-----
My recordsource returns currency amounts per client per
project. In the
report I show the amounts per project then show the sum
of the amounts per
client in the client group footer.

How would I group these summed amounts in descending
order in the report?

regards

Terry


.