3 conditions formula Version: 2003

[spalla]

can anybode tell me how i can set a control with a formula that looks for 3 conditions example:

if field a = xx than "formula"
if field a = yy than "formula"
if field a = zz than "formula"

thank you for your help

 

[TheAceMan1]

How are ya spalla . . . .

Try this in the [blue]Control Source[/blue] of the Control:

[blue]=IIF(fieldA = xx, formula xx, IIF(fieldA = yy, formula yy, IIF(fieldA = zz, formula zz, ""))
)[/blue]

See Ya! . . . . . .

 

[TheAceMan1]

spalla . . . .

That last parenthese didn't come out right. Here it is corrected:

[blue]=IIF(fieldA = xx, formula xx, IIF(fieldA = yy, formula yy, IIF(fieldA = zz, formula zz, "")))[/blue]

If you have any problems, post it back as you have it . . .

See Ya! . . . . . .

 

[spalla]

thanks a lot

 

[spalla]

one mor little question what about if i want to leave the 3rd condition without a formula and i want to imput the value manually?

if field a = zz than "manual imput"
is there a way to do that?

 

[TheAceMan1]

OK spalla . . . . .

Replace with the following:

[blue]=IIF(fieldA = xx, formula xx, IIF(fieldA = yy, formula yy, IIF(fieldA = zz, [b]InputBox("[purple]PromptText[/purple]","[purple]TitleBarText[/purple]")[/b], "")))[/blue]

See Ya! . . . . . .

 

[spalla]

thank you again