IIF function for yes/no column?

[Guest]

i have a column in a table with only yes/no data in it. i need to make a
report for all of the records that have the "no" response in the column. i
figure i have to do it through a query with the "IIF" statement, but i am not
sure how to ignore all ofthe "yes" responses, and sent the "no" responses to
populate the form. i need to know the proper expressions to use. i am using
access 2003. thanks in advance.

 

[Duane Hookom]

You should be able to set the criteria under the "column in a table with
only yes/no data in it" to
=0

 

[Marshall Barton]

i have a column in a table with only yes/no data in it. i need to make a
report for all of the records that have the "no" response in the column. i
figure i have to do it through a query with the "IIF" statement, but i am not
sure how to ignore all ofthe "yes" responses, and sent the "no" responses to
populate the form. i need to know the proper expressions to use. i am using
access 2003.

Just setting the yes/no column's criteria to False should be
sufficient.