Double chk box Expression Help Needed 1

[number2]

I want to return a value if 2 different check boxes are checked (-1) Something like:

IIf([rtxtchk]=-1) And IIf([ltxtchk]=-1),[bilattxt],"")

What is wrong with this expression? (sorry, I have been working too many hours !!)

 

[TheAceMan1]

How are ya number2 . . . . .

Try this:

[blue]IIf([rtxtchk] And [ltxtchk],[bilattxt],"")[/blue]

See Ya! . . . . . .

 

[number2]

Hey Ace, thanks a million. Works like a charm as:

IIf([righttxtchk] And [lefttxtchk]=-1,[bilattxt],"")

This is easily the 100th time this forum as saved my bacon!

 

[TheAceMan1]

number2 . . . . .

Although your last post will work, your not seeing the logic. The result returned from the expression [blue][Value1] And [Value2][/blue] is what your missing.

[blue]IIf([Value1] And [Value2],[bilattxt],"")

If [blue][b]Value1[/b][/blue] is IF [blue][b]Value2[/b][/blue] is [purple][b]Result[/b][/purple] is
------------ ------------ ---------
False        False        False
False        True         False
True         False        False
True         True         True

After the expression is evaluated the IIf really looks like this:

IIf([purple][b]Result[/b][/purple],[bilattxt],"")[/blue]

See Ya! . . . . . .