I can get my query & report to show this:
Product sumCost
A $200
B $600
C $500
I want it to look like:
Product sumCost
B $600
C $500
A $200
Thanks in advance
I can get my query & report to show this:
Product sumCost
A $200
B $600
C $500
I want it to look like:
Product sumCost
B $600
C $500
A $200
Thanks in advance
It looks like you want to add the amount field in Sorting and Grouping.
When I add cost as a group I get each record $ and then each catagory. If I could have sumCost as a group and list highest to lowest in my mind it would work. But sumCost is not a field in the list.
Please advise how to do this simple task.
Thanks
Based on your sample, I don't see any grouping, just a sort on amount. Can you post the db?