finding max value in control of form

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?
 
W

Wayne Morgan

See if this equation will do it.

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Max function??? 1
Next month 4
pass a value 1
Assigning values to text for calculation 0
Word Word 2007 form fails to auto calculate total 5
Text parsing help needed 9
Word Word 2007 form calculate field fails to udate when data entered 1
If a control contains this value, do this... 6

Top