How do you get the greatest value

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

The report is really ugly, so I will not get into detail.
How do I get a maximum value of a single field to show up on the page footer.
If I have a text box and it generates a number, how can I get a maximum
value at the end of the report.
Details (New line item for each date):
01/01/05 3.00 hrs
01/15/05 6.00 hrs
01/21/05 2.00 hrs

Footer:
Answer = 6.00 hrs
 
Make up your mind whether you want the maximum "on the page footer" or "at
the end of the report". If "at the end of the report" is correct, set a
control source of a text box to:
=Max([Your Field or Expression])
 
Back
Top