Sorting a report based on a calculated field...

  • Thread starter Jason Lambertus
  • Start date
J

Jason Lambertus

Greetings all,

I've poked around in the report forum for a while now and
don't see anything that matches what I am looking for.

I have a report that is generated from a query. The query
contains a field called ItemCost. There is also a field
called Prefix. I am grouping the report based on the
Prefix field and summing the ItemCost field in the Prefix
Footer.

Now, here's where I stumble. I would like to sort the
groups based on the sum of the ItemCost field for each
group.

The sum field for ItemCost is currently calculated on the
report.

Any suggestions would be greatly appreciated.

Thanks,

Jason
 
Top