Order by sum value in group footer section

[Leslie Isaacs]

Hello All

I have a report with a currency field [fee] in the detail section and a
field in a group footer section with a value set to =Sum([fee]). Is it
possible for this report to display the 'groups' in order of the value of
Sum([fee]? I have tried all sorts to get this to happen, but have failed!

Hope someone can help.
Many thanks
Les

 

[Duane Hookom]

You can only sort/group by expressions from single records in your report's
record source. You might be able to create a totals query similar to your
report's record source that groups and then sums by Fee. Add this totals
query to your report's record source so that you can use it.

 

[Leslie Isaacs]

Hello Duane

Many thanks for your help.
Your idea worked out a treat!

Thanks again
Les

You can only sort/group by expressions from single records in your report's
record source. You might be able to create a totals query similar to your
report's record source that groups and then sums by Fee. Add this totals
query to your report's record source so that you can use it.

--
Duane Hookom
MS Access MVP

Hello All

I have a report with a currency field [fee] in the detail section and a
field in a group footer section with a value set to =Sum([fee]). Is it
possible for this report to display the 'groups' in order of the value of
Sum([fee]? I have tried all sorts to get this to happen, but have failed!

Hope someone can help.
Many thanks
Les