Maximum Value from Multiple Fields

[Brian C]

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.

 

[Eric Cárdenas [MSFT]]

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.

--------------------
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,