max function in a form

[Guest]

Hello,
I have a form, and I want to find the maximum between:
[text7]-[text5] and zero. (Of course, text7 and text5 are two text boxes in
my forms connected to some queries. They do work.)

My try of:
=MaxA(([text7]-[text5]),0) didn't work...

Any ideas?
Thanks!
(And Merry Christmas!)

 

[Allen Browne]

You want a zero if text5 is greater than text7?

Try a Control Source of:
=IIF([text5] > [text7], 0, [text7] - [text5])

If there are actually more fields involved, and you need to find the largest
one, see:
http://members.iinet.net.au/~allenbrowne/func-09.html