Grouping in Reports

[klp via AccessMonster.com]

I kinda put a post on here previously but didn't quite make myself clear. So
I'm trying it again.

I have a report that I want to group by Customer ID then sort by descending
dollar value.

IE) 123 1900.00 (The values being a summary of all orders for
that customer)
456 1500.00
789 200.00

Problem: The sorting and grouping in the report will not work since it's
doing a summary on each customer. I've tried the autosum options in my query
but doesn't do what I expect it to do. Is there another way to get around
this problem?

 

[Duane Hookom]

This doesn't make sense if your report's record source only contains one
record per customer. It would not make sense to then group/sort by customer.

If your record source contains multiple records per customer, you can't sort
by an aggregate calculated in the report. You would need to calculate the
and place the aggregate in the report's record source query.