Highest Value of a field on forms

  • Thread starter Thread starter Al
  • Start date Start date
A

Al

I better start with the background :
I am designing a cricket statistics database on Access 2000.
I have a form with people's details which has a subform with their
statistics. On the subform's footer I have put text boxes with expressions
such as "SUM([Matches Played)" for a totals row. However one statistic is
High Score (HS) and in the totals row at the footer, I need an expression to
pick out the greatest of the high scores and display it. The expression
editor doesn't seem to have a function for this.


Al O'S
(e-mail address removed)
 

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

Highest value on report 4
What do I do if my subform has no data? 5
Displaying the Total from a Subform on a Main form 7
Sum a field in a form 1
Linking fields based on ranges 4
populate and update textbox 1
Default values from a subform (Access 2003) 8
Displaying the total from a subform onto a main form. Pleas Help! 5

Back
Top