Using IIf staements on yes/no commands in query expressions

  • Thread starter Thread starter Dougt
  • Start date Start date
D

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......
 
Dougt said:
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......
Click to expand...

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".
 
Back
Top