Iif Wird Problem Message

maniatis

Registered User.
Local time
Today, 18:54
Joined
Sep 22, 2005
Messages
31
i try to do this:
i use the iff syntax in the control source of a text box in a form and even though the syntax is correct the programmes says wrong syntax.I use access 2002-2003 with service pack1 and i have this problem. i know my syntax is corect becasuse i used the sam in access 2003 and it works.here is the syntax in the expression box:

=iif([C_CASE_DATE]=[C_CASE_LA], "VESSEL INFO","

I WANT IN THE TEXT BOX TO SHOW ME VESSEL INFO WHEN THESE TWO FIELDS ARE EQUAL.

I DON'T KNOW WHAT'S WRONG. ANY SUGGESTIONS PLEASE! :confused:
 
Don't you need a closing parentheses?
or maybe..
..."VESSEL INFO","")?
 
use a semicolon instead of a comma
regards
K
 

Users who are viewing this thread

Back
Top Bottom