IIf Expression, or use something else?

[tim.cassey]

I am currently using an IIf expression within a report to either display one symbol (an empty checkbox), or to display another symbol (a ticked checkbox), depending on if a particular field in a table is checked or not (yes or no box).

What I need to do, is have a third argument... where if an item does not have the box checked, and also is of a particular model, the symbol that should display is a filled in check-box (indicating that it doesn't apply to this).

If this doesn't make sense let me know and I'll post some dummy data, I just didn't know if expressions could do this within a report.



Thanks for any help.

[CJ_London]

investigate using nested iifs or the choose function (which is a bit like a case function)

iif(a=b,1,iif(a=c,2,3))

or

choose(a=b,1,a=c,2,true,3)

or a combination

choose(a=b,1,iif(a=c,1,2))

[tim.cassey]

I'll give it a try and let you know how I go. Thanks very much!

[tim.cassey]

I'm getting a bit confused when trying to put it all together, and I think it's a bit more complex than I thought.

I have 5 models I want to check against: 1,2,3,4,5

Basically what I want to achieve is:

IF Checkbox = Yes, Then display "TICK", Else Display "UNCHECKED BOX"

Although IF Model=1,2,3,4,5 THEN display "FILLED IN BOX"


Not sure what to use in expressions

[tim.cassey]

Ended up using nested IIf statements. Attempted to use the SWITCH statement but it wasn't working for me... a bit messy but it got the job done.