Access Problem

[Denburt]

BTW, the same type problems arise when dealing with the Choose() and Switch() Functions within the same context.

I will remember this...

Glad you got it Mike

[Rabbit]

BTW, the same type problems arise when dealing with the Choose() and Switch() Functions within the same context.

I only tested in SQL as that is the only place I would use iif().

[Denburt]

I only tested in SQL as that is the only place I would use iif().

Did you see the article I posted earlier about using it in a query?
iif() and SQL

I posted more in this article than I wanted to so if someone wouldn't mind cleaning some of it out I just wanted the portion about the iif() statement...