IIF Statement not working?

[mosh]

Hi All,

I have a table that contains a questionnaire with 3 possible values for each (Yes/No/N/A).

I am creating a sub-query for each column so i get a value according to the answer given, e.g; if Yes selected, then value of 3.85 given, else 0. I am using the following statement:

Expr1: IIf([tbl_quality_assessments2]![Core_1_Notes]="Yes",1,0)

But it is giving all 0 values when "Yes" is the value in the table. Any ideas?

Thansk,
________
Luv2Playxxx

 

[ajetrumpet]

more than likely, you have a "yes/no" field set, and the values you're looking for are -1 and 0.

-1 = yes, 0 = no....OR -1 = checked box, 0 = unchecked box

 

[mosh]

The Fields are set as text with a lookup table containing "Yes", "No", "N/A",
________
blonde girl Webcams

 

[DCrake]

If you also list the core 1 notes field in your query do you see different values (Yes, No & N/A)?

Do they all have 0 in the IIF()?

David

 

[mosh]

Yes,

When i drop in the value i get the following:

EXPR1: Expr1: IIf([Core_1_Notes]="Yes",1,Null)

Core_1_Notes Expr1
Yes #Error

Yes #Error
Yes #Error
Yes
Yes
Yes

Yes
Yes
Yes
Yes
Yes
Yes
________
Iolite vaporizer colors

 

[mosh]

can anyone help?
________
Marijuana Seed

 

[DCrake]

Can you send me the table? Or at least a snippet of it?

I could create it myself but it may be something at your end that is doing it. Pre 2007 please.

David

 

[mosh]

thanks DCrake,

Ill message you with details.

Regards,
________
CALIFORNIA DISPENSARY