IIf

K

kevcar40

Hi,
i have a text box on an input form
i want to compare 2 textbox values then perform a calcualtion on the
result

an example of what i am trying is below

iif([text610]>[text613], [text610]/2), iff([text610]<[text613],
[text613]/2)

can i do this using a formula

thanks

kevin
 
S

S.Clark

Create a new textbox, call it txtCalc

Set the control source to:

=iif([text610]>=[text613], [text610]/2, [text613]/2)
 
Top