Sorting/Grouping Report

D

D_K

Hello,

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

Thanks,

D_K
 
R

Rick B

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
 
D

Duane Hookom

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.
 
D

D_K

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
 
R

Rick B

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
 
D

Duane Hookom

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.
 
Top