Hello,
I need some help on a report. I have a report that is grouped by Client Name (which there are many) and then summing up all their expenses in a given period of time so I have this:
AAA Company
=Sum([Expenses]) $14,000
And then in counts how many records that particular client has...
Also, this report is based on a query that I built that pulls in our clients and all their expenses and then prompts on a date so you can type in which ever dates you want.
Now, this is exactly what I need but instead of being sorted by Client Name (grouped by), they want to see the client that has the highest amount expenses first and I cannot figure out how to get that...if I choose the sort under the group it just sorts within that group...not what I want.
Any ideas?
Thank you.
Lisa