Originally posted by leeroy
As three different fields change on a form I'd like a 4th field to always equal the highest of the other three. Would I use an if then statement or is there some "max" function I can use?
you would have to use an if then function to evalueate the three fiields, id even use and iif statment to make it simpiler
iif(field1 > field2 and field1 > field3, textbox=field1, iif(field2 > field1 and field2 > field3, textbox=field2,iif(field3 > field1 and field3 > field2, textbox = field3)))
something similure to that should do the trick