IIF function for yes/no column?

C

crhp917

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.
 
D

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
 
M

Marshall Barton

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


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