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])
 

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

Group in Columns 4
Access Running Balance in Access 1
Using "Avg" function on calculated field 3
How to add a total from three other sums in a report 5
Finding minimum based on criteria of another field 1
Crosstabquery to fill a report.... 2
How to Sum Total cost field in report 2
How do I Turn a Spreadsheet Type format INTO....PLEASE HELP! 8

Back
Top