Sorting/Grouping Report

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello,

Is there any way for me to sort a report by a calculated field that is on
the report footer?

Thanks,

D_K
 
Well, if it is on the footer, then what would you sort? The report footer
only prints once, so sorting by it would make no sense. "Total Records =
124" <--- Nothing to sort.

If you ahve a calculated field that is in the detail section or in a group
footer, then yes, you can sort by that.

Rick B
 
Actually, you can't sort by a value that is "aggregated" in a group footer
(or header). For instance if you had sales grouped by SalesPerson with a
total sales in the SalesPerson footer, you could not sort your report based
on the Sum of Sales. You would need to create a totals query by SalesPerson
to sum the sales. Then add this totals query to your report's record source
so that you could then sort by the SumOfSales.
 
Sorry about the wording....

I need to sort by a calculated field that is in the footer of a detail
section. How do I do that?

Thanks,

Dan
 
Duane: Good point. After looking, the one report that I have which is
sorted by group footer works the way you mention. I'm sure that I got the
advice on how to do it on this newsgroup.

Thanks!!!

Rick B
 
Check again. Detail sections don't have footers either. Sorting levels have
footers and headers. Please check other responses in this thread for
possible solutions.
 
Back
Top