<!DOCTYPE HTML PUBLIC "-//W3C//DTD HTML 4.0 Transitional//EN">
<HTML><HEAD><TITLE>Message</TITLE>
<META http-equiv=Content-Type content="text/html; charset=iso-8859-1">
<META content="MSHTML 6.00.2800.1141" name=GENERATOR></HEAD>
<BODY>
<DIV><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff size=2>You
probably need to give us more details but I tend to agree in philosophy with the
idea that IIF should not be used unless necessary. But in practice it is
sometimes necessary. I have it used it mostly when querying a pre-existing
database which is poorly normalized (hmmm, that might be an oxy-moron).
</FONT></SPAN><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff
size=2>I use it as a guideline not a rule though, the only "rule" I tend to have
is to never rule out anything.</FONT></SPAN></DIV>
<DIV><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff size=2>I
think the biggest drawback beyond speed is that its Access specific and
t</FONT></SPAN><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff
size=2>hey can be difficult to read. I think "spreadsheet people" love it
though.</FONT></SPAN></DIV>
<DIV><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff
size=2></FONT></SPAN> </DIV>
<DIV><SPAN class=450540520-31032003><FONT face=Arial color=#0000ff
size=2>JB</FONT></SPAN></DIV>
<DIV><SPAN class=450540520-31032003></SPAN><FONT face=Tahoma><FONT size=2><SPAN
class=450540520-31032003><FONT face=Arial
color=#0000ff></FONT></SPAN></FONT></FONT> </DIV>
<DIV><FONT face=Tahoma><FONT size=2><SPAN
class=450540520-31032003> </SPAN>-----Original Message-----<BR><B>From:</B>
accessd-bounces@databaseadvisors.com
[mailto:accessd-bounces@databaseadvisors.com]<BR><B>Sent:</B> Monday, March 31,
2003 1:39 PM<BR><B>To:</B> accessd@databaseadvisors.com<BR><B>Subject:</B>
[AccessD] IIf in query discussion<BR><BR></DIV></FONT></FONT>
<BLOCKQUOTE dir=ltr style="MARGIN-RIGHT: 0px">
<DIV><FONT face=Arial size=2><SPAN class=866540619-31032003>Recently I read an
article by an Access expert who suggested that using 'iif' in a query is
a rookie mistake.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=866540619-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=866540619-31032003>I've made that
mistake.</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=866540619-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN class=866540619-31032003>My
question: Does using 'iif' in a query just slow done processing, or, does
it have more substantial consequences?</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=866540619-31032003></SPAN></FONT> </DIV>
<DIV><FONT face=Arial size=2><SPAN
class=866540619-31032003>TIA,</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2><SPAN
class=866540619-31032003>Myke</SPAN></FONT></DIV>
<DIV><FONT face=Arial size=2></FONT> </DIV></BLOCKQUOTE></BODY></HTML>