IIF not working for me!

[JT]

this is where i am at....
=IIf([SFUWO Qualifications]![Initial Dive Training]="CDQC","X"," ")
i am trying to have a text box with this function in it,. where if in the
"SFUWO Qualifications" database and the "Initial Dive Training" field is
equal to "CDQC" then it places an "X" in the text box otherwise it leaves the
text box blank..... i am currently receiving an "#ERROR", prior to that i was
receiving nothing at all.
Please Help
Thanks
JT

 

[George]

JT,

"SFUWO Qualifications" database ?? or table?

Try the following:

Ο χÏήστης "JT" έγγÏαψε:

=IIf[Initial Dive Training]="CDQC","X"," ") or

=IIf[Initial Dive Training]="CDQC";"X";" "), assuming that the Initail Dive
Training is a field (textbox) in your form or report.

George

 

[BruceM]

Don't forget the opening parentheses after the IIf:
=IIf([Initial Dive Training]="CDQC","X"," ")

It should work if Initial Dive Training is a field in the record source but
not a text box. I expect there is a text box bound to the field, so this is
just a general observation that it doesn't have to be a text box.

JT,

"SFUWO Qualifications" database ?? or table?

Try the following:

? ??????? "JT" ???????:

=IIf[Initial Dive Training]="CDQC","X"," ") or

=IIf[Initial Dive Training]="CDQC";"X";" "), assuming that the Initail
Dive
Training is a field (textbox) in your form or report.

George

this is where i am at....
=IIf([SFUWO Qualifications]![Initial Dive Training]="CDQC","X"," ")
i am trying to have a text box with this function in it,. where if in the
"SFUWO Qualifications" database and the "Initial Dive Training" field is
equal to "CDQC" then it places an "X" in the text box otherwise it leaves
the
text box blank..... i am currently receiving an "#ERROR", prior to that i
was
receiving nothing at all.
Please Help
Thanks
JT