Group on results of calculated value

[Terry]

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

 

[Fons Ponsioen]

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

 

[Terry]

Thanks Fons,
All done OK.
Regards

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