crazy_fuzzy_bunny

I am trying to run a query for a report that will pull the value of a Field when the checkbox is selected (-1) or nothing if it is not checked. I can't seem to get the syntax right to pull the needed information and I'm not sure if I should use and IIF or If else in VBA. Any recommendations?

Sample IIF that isn't working:

IIf([question2_check]='-1',

'[question2]','Null')

I am running a query which is listed below that is looking for a -1 in each check field then if it has a -1 then I want it to return the value for the text field it represents. If it has a value of 0 or null then return nothing at all. It is not returning any values and I could use some help on the formatting of the IIF statement. Something is just not right.

SELECT Survey_Feed.Session_ID, Survey_Feed.Question2_check, Survey_Feed.Question5_check, Survey_Feed.Question9_check, Survey_Feed.Comment_check

FROM Survey_Feed

WHERE (((Survey_Feed.Question2_check)=IIf([question2_check]='-1','[question2]','')) or ((Survey_Feed.Question5_check)=IIf([question5_check]='-1','[question5]','')) AND ((Survey_Feed.Question9_check)=IIf([question9_check]='-1','[question9]','')) AND ((Survey_Feed.Comment_check)=IIf([Comment_check]='-1','[Disposition_Comments]','')) AND ((Survey_Feed.Submit_Time)=Date()-10));

The most common question we see around here is which martial art is best. Also which martial art should I take if I want to go into UFC , K1 or other tournaments like them. I think something that people need to understand is that martial arts are different from martial sports. Those tournaments have specific rules that guide them. Because someone who has trained extensively in certain other martial arts make it impractial for them to participate. Yes they are great fighters, but someone who is trained to break bones whenever they can can't play in that world. Does that make them less a martial artist than someone who has been in Aikdo 20 years? No, just different. Is either better than the other? Who cares? Each style does what it is designed to do and they will most likely never meet because UFC and the others do not have a reality based rules set. They actually have rules where real life does not.

What are your thoughts?