>Hello,
> Is an IIF() faster than an If-Else-Endif statement?
As has been stated, yes it is. However, Bret's readability point is an excellent one. Unless conditions exist that make it absolutely necessary (in a loop with a large number of iterations, for example), my feeling is the the speed difference is so minimal, that using the IF/ELSE/ENDIF block is the way to go.
Personally, I tend to use IIF() only in reports and in queries.
George
Ubi caritas et amor, deus ibi est