Another Undefined Function

I have the following query that gives me the Undefined Function 'Iff"

SELECT tblStudent.StuLastName, tblStudent.StuFirstName, tblStudent.StuMI,
tblStudent.StuDOB, Iff(IsNull([tblStudent.StuDOB]),0,-1) AS MyTest
FROM tblStudent;

I have checked the references and none are missing. I have added and deleted
a reference and that did not help either.

What I am trying to do is check a date field and if it is empty get a 0 I can
put on a report in a check box, otherwise I want a -1 for the same reason.

TIA for the help.

--
Message posted via http://www.accessmonster.com

The function is IIF not IFF.

I always think of it as *I*mmediate *IF*

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County

SElgin via AccessMonster.com wrote:
> I have the following query that gives me the Undefined Function 'Iff"
>
> SELECT tblStudent.StuLastName, tblStudent.StuFirstName, tblStudent.StuMI,
> tblStudent.StuDOB, Iff(IsNull([tblStudent.StuDOB]),0,-1) AS MyTest
> FROM tblStudent;
>
> I have checked the references and none are missing. I have added and deleted
> a reference and that did not help either.
>
> What I am trying to do is check a date field and if it is empty get a 0 I can
> put on a report in a check box, otherwise I want a -1 for the same reason.
>
> TIA for the help.
>