>I'm sure that this has already been covered.
>
>Any real benefits to use iif instead of if...else...endif?

They have different purposes. IF/ELSE/ENDIF is a flow control structure. IIF() is a function which returns an expression based on whether a condition is true. IIF() is fine if you just want to populate a variable with a value.