Re: IIF function in query

From: Ray Higdon (sqlhigdon_at_nospam.yahoo.com)
Date: 03/18/04 

Date: Thu, 18 Mar 2004 05:30:33 -0500

If you are trying to use Access's IIF function, use a case statement. See
BOL for details 

-- 
Ray Higdon MCSE, MCDBA, CCNA
---
"Pegleg" <anonymous@discussions.microsoft.com> wrote in message
news:f2f601c40ca5$07b201a0$a301280a@phx.gbl...
> I'm try to set an IIF statement in a query/view for a
> column.  I repeatedly get an error message stating the IIf
> function doesn't exist.  When I try IF, it put my function
> in 'quote marks'.
>
> Please help