Using IIf staements on yes/no commands in query expressions

[Dougt]

I have a IIf query expressionas follows:
IIf([wheel broken]="yes",([standard]-[parts ground])*
[wheel price],"no charge") - this expressions shows error
in field. The IIf statements checks whether the yes/no
combo box for the [broken wheel] field was checked
(indicating "yes") it calulates the wheel charge, if not
checked, it shows "no charge" in field. Please help......

 

[Rick Brandt]

I have a IIf query expressionas follows:
IIf([wheel broken]="yes",([standard]-[parts ground])*
[wheel price],"no charge") - this expressions shows error
in field. The IIf statements checks whether the yes/no
combo box for the [broken wheel] field was checked
(indicating "yes") it calulates the wheel charge, if not
checked, it shows "no charge" in field. Please help......

Is [wheel broken] a Text Field actually storing the words "yes" and "no",
or is it a Yes/No field that is merely formatted to display the words "yes"
and "no"? If the latter you might need to test for <> 0 instead of ="yes".