Problem With Iff Command

[maniatis]

I Have The Following Problem:
I Write In The Expression Box The Syntax Of Iff Command With The Following Syntax:
=iif([date1]=[date2],"vessel","auto")
And I Receive The Message That Is Sth Wrong.
In My Pc At Home The Command Works Fine In Work's Pc It Doesn't Work.
Please Help I Don't Know What's Wong.
Thanks

 

[ghudson]

Then I would check for a missing reference. Are you using the same version of MS Office [Access] on both PCs?

 

[maniatis]

I Haven't Copied The File From The Home Computer To The Work Computer. I Just Testied The Syntax Of The Command Iff To My Home Pc That Has A Previous Version (access 20002) And It Worked Fine.i Have Version Access 2003 With Sp1 To My Work Computer.
The Syntax I Use Is The Following:
=iif([c_case_date] = [c_case_la], " Vessel"," ")

The Message I Get Is Invalid Syntax.

Do U Think Sth Wrong With The Syntax?

Do U Think Sth Missing Or It Is Wrong?

I Just Can't Get It How In My Home Computer The Same Syntax Works. The Fields Are Correct So Where Is The Problem?
Thanx