MAXA Function

[Nosdron]

On a form I want to read a maximum value from a calculated field eg Length. So = MAXA ([Length],0). This gives me a #Name error though ? Why?

Angela

 

[danvlas]

Because the function name is Max, not MaxA

Dan

 

[Nosdron]

There is a MAXA function in the help topics ! The Max function will not work on logical values or text.

 

[danvlas]

There is a MAXA function in Excel. But not in Access (as far as I know).

Are you sure ?

Dan

 

[Nosdron]

It was on the access help ? But maybe I am mistaken. I take it you cant use a MAX function on a calculated field then ?

 

[danvlas]

Max should work. However, if you have text values in the calculated expression, it will evaluate all values as strings.

Dan