"Ed" wrote:

> try
> case when dbo.tblCaks.[DocType] = 'DR' Then 'True' Else 'False End as
> AnyNamehere
>
> Ed
>
> "Nickl" wrote:
>
> > I have a problem using the IIF function in an Access Project. I am trying to
> > use it in a view/function, in the column grid of the designer, but I get the
> > error "ADO error: iif is not a recognised function name" when I try to save
> > the View/function.
> >
> > THe expression I am attempting to use is;
> > IIF (dbo.tblCaks.[DocType] = "DR","True","False")
> >
> > DocType is a char field, and other functions are working fine (eg LEFT, RIGHT)
> > Any suggestions as to how I can make the IIF function work would be
> > appreciated.
> >
> > Thanks
> >