Similar to MAXA worksheet function

[Bruce]

I would like to find the MAX value from 3 fields (i.e. f1, f2, f3).

I could do this the long way with IFF (i.e. iif(f1>f2 etc), but is there a
function like MAXA that can do this? Am using Access 2k with SP3

Rgds,

Bruce

 

[Allen Browne]

Use a function like MaxOfList() from:
http://allenbrowne.com/func-09.html