Sorting by Calculated Field in Report Footer

  • Thread starter Thread starter BJ Eisner
  • Start date Start date
B

BJ Eisner

I am using Access 97. Is there any way to sort on a
calculated sum field in a report footer?

My report is sorting/grouping on field [Physician Group
Name] (Group Header and Footer is set to yes for this
field)and then sorting/grouping on field [Physician Last
Name]. I have calculated sum fields in the footer for the
[Physician Group Name] and would like to sort by one of
the calculated sum fields.

This is my first time using the newsgroup....please let me
know if my explanation is confusing.

Thank you!
B.J.
 
The simplest way to accomplish that is to include the
calculated value in the query underlying the report.
Hope this gets you going
Fons
 
Back
Top