Maximum Value from Multiple Fields

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

Guest

I have a form based on a table. In the footer, I am making calculations based on the numbers in the fields of the detail section. Of a given set of 4 different fields, I want to determine the maximum (and minimum) values

I have tried using the Max and MaxA functions in the control property of the field in the footer. Neither function is working

Any suggestions? Thanks.
 
I have a form based on a table. In the footer, I am making
calculations based on the numbers in the fields of the detail
section. Of a given set of 4 different fields, I want to
determine the maximum (and minimum) values.

I have tried using the Max and MaxA functions in the control
property of the field in the footer. Neither function is
working.

Any suggestions? Thanks.
Click to expand...
--------------------
Did you find to determine the maximum value amongst Column1, Column2 ...
ColumnN? If so, the Max functions won't do it. You would need to write your
own user-defined function in VBA to do this.

Hope this helps,
 
Back
Top