Group on results of calculated value

  • Thread starter Thread starter Terry
  • Start date Start date
T

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
 
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
 
Thanks Fons,
All done OK.
Regards

Fons Ponsioen said:
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
Click to expand...
 
Back
Top