Find the Max value in a Footer os a Report?

[mmck1964]

I have a report that looks in the detail section of my report and adds the numbers together for each month to give me a total per month. My expression is in the footer section of my report and I have 1 expression for each of the 12 months. It works fine, but now I want to find the max value over the 12 months that are listed. Can I do this within the same footer section. I can't get it to work.
Thanks!

 

[PaulBricker]

What have you tried? You will need something like a DMax Function to get the value for each Footer.

Paul

 

[mmck1964]

All of my monthly totals are in the same footer. There are 12 text boxes with a calculated value in the footer. I want to find the max number that resides inside the 12 text boxes and show it on the report. It seems like DMAX wants to look back at a table or a query.

 

[PaulBricker]

DMax does want to look back, but your Report probably has an underlying Table/Query so I thought using DMax would be an option. Is it not an option?

Paul