[thelist] Conditionals in Access
Scott Brady
evolt at scottbrady.net
Sat Nov 1 19:39:23 CST 2003
Ken Schaefer wrote:
>I think IIF() will do what you want:
>
>IIF(expression, true part, false part)
>
>If expression is true, then true part is returned, else false part is
>returned.
>
>
>
Yep, the IIF did the trick (Another reader helped me offlist with the
same idea and the same dislike for the Access help files).
>Also, IN() is very slow in Access if you have lots of records. Try using an
>EXISTS or NOT EXISTS query instead. Also, make sure you have appropriate
>indexes defined.
>
>
>
Actually, I was also able to accomplish what I was trying to do without
the subquery and put it within the main query, so it's much simpler now.
Scott
--
---------------------------
Scott Brady
http://www.scottbrady.net/
More information about the thelist
mailing list