finding max value in control of form

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

Guest

i have a three control the text1, text2, and text3. but in the text4, i want
to return the maximun value of the three control. what will i do?
 
See if this equation will do it.

=IIf([Text1]>=[Text2] And [Text1]>=[Text3], [Text1], IIf([Text2]>=[Text3],
[Text2], [Text3]))
 
Back
Top