[AccessD] IIF Function

But they didn't ... you did!

Ha ha ha I crack myself up.

No offense, really, I am just in a wacky mood.




On Tue, Sep 6, 2011 at 3:31 PM, Tesiny, Ed <EdTesiny at oasas.ny.gov> wrote:

> Paul/Asger,
> Of course you're right...I hate it when you make a mistake with a ")"
> Thank you!
>
> Ed Tesiny
> EdTesiny at oasas.ny.gov
>
>
> -----Original Message-----
> From: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] On Behalf Of Asger Blond
> Sent: Tuesday, September 06, 2011 3:25 PM
> To: 'Access Developers discussion and problem solving'
> Subject: Re: [AccessD] IIF Function
>
>
> IIf(DateDiff("d",[RSSApplicationApproved],[Lureen_Reviewed_Date])<3 And
> [Lureen_Reviewed]<>2,"OK","Followup")
>
> Asger
>
> -----Oprindelig meddelelse-----
> Fra: accessd-bounces at databaseadvisors.com [mailto:
> accessd-bounces at databaseadvisors.com] På vegne af Tesiny, Ed
> Sendt: 6. september 2011 21:16
> Til: Off Topic; Access Developers discussion and problem solving
> Emne: [AccessD] IIF Function
>
> Hi All,
>
> I have the following IIF statement in a query:
>
>
>
> LureenRev1:
> IIf(DateDiff("d",[RSSApplicationApproved],[Lureen_Reviewed_Date]<3 And
> [Lureen_Reviewed]<>2),"OK","Followup")
>
>
>
> RssApplicationApproved  06/17/2011 (Date)
>
> Lureen_Reviewed_Date 06/16/2011 (Date)
>
> Lureen_Reviewed 2 (long integer)
>
>
>
> The statement returns    OK
>
>
>
> Could someone tell me what's wrong with it, I can't see what's wrong.
>
> TIA,
>
> Ed
>
>
>
> Edward P. Tesiny
>
> Director of Evaluation and Outcomes Management
>
> New York State OASAS
>
> 1450 Western Avenue
>
> Albany, NY 12203
>
> Phone:  (518) 485-2322
>
> Fax:  (518) 485-5228
>
> EdTesiny at oasas.ny.gov <mailto:EdTesiny at oasas.state.ny.us>
>
>
>
> IMPORTANT:  This E-mail may contain confidential material for the sole
> use of the intended recipient.  The use, distribution, transmittal or
> re-transmittal by an unintended recipient of any communication is
> prohibited without our express approval in writing or by e-mail.  Any
> use, distribution, transmittal or re-transmittal by persons who are not
> intended recipients of this e-mail may be a violation of law and is
> strictly prohibited.   If you are not the intended recipient please
> contact the sender and delete all copies.  E-mail transmission cannot be
> guaranteed to be secure or error-free.   The sender therefore does not
> accept liability for any errors or omissions in the contents of this
> transmission.   All e-mails sent to or from NYS OASAS are to be used for
> our business purposes only.  E-mails sent from or to NYS OASAS are
> subject to review by the Agency.
>
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>
> --
> AccessD mailing list
> AccessD at databaseadvisors.com
> http://databaseadvisors.com/mailman/listinfo/accessd
> Website: http://www.databaseadvisors.com
>



-- 
*Regards,*
**
**
*Bill Benson*
*VBACreations*
**
PS:  You've gotten this e-mail *because you matter to me!*