[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