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!
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!