Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Find the Max value in a Footer os a Report?

Status
Not open for further replies.

mmck1964

Technical User
Jul 12, 2001
104
US
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!

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

Paul
 
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.
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top