Date: Thu, 9 Sep 2010 23:32:01 -0400
Reply-To: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Sender: "SAS(r) Discussion" <SAS-L@LISTSERV.UGA.EDU>
From: Sigurd Hermansen <HERMANS1@WESTAT.COM>
Subject: Re: Access "IN(IS NULL, '2' " question........
Content-Type: text/plain; charset="us-ascii"
More typically a query would have
where Variable IS NULL or Variable IN ('2', ....)
From: SAS(r) Discussion [mailto:SAS-L@LISTSERV.UGA.EDU] On Behalf Of Craig Johnson
Sent: Thursday, September 09, 2010 3:43 PM
Subject: Access "IN(IS NULL, '2' " question........
Is there a trick to getting the IS NULL option to pass through to access and
work in an IN operator? For example.......
Where Variable In(Is Null, '2');
I can't figure out how to get it work or if it is even possible (
http://www.devx.com/vb2themax/Tip/18541). Yes, I realize I could rewrite
the code a couple of different ways it just seems like I should be able to
add the "Is Null" option in.............