Sorting by Calculated Field in Report Footer

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

Fons Ponsioen

The simplest way to accomplish that is to include the
calculated value in the query underlying the report.
Hope this gets you going
Fons
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access MSACCESS - Sorting report based on field calculated in the report 0
Include totals in footers to fields in layout collection (2007) 1
Report - Sorting and Grouping 1
How to count records using count(*) in a chart report 3
Sum Calculated Fields in Report Footer 1
Adding something in reportfooter changes sorting 2
How do I sort by calculated field 1
Sum unique entries in report footer 2

Top