displaying only results that equal no

[Seth Kenney]

i have a query in which the user is prompted to enter a persons name and the query displays that persons information from a table. In the table i have some fields which are yes/no check box's. Is there any way to display just the fields that are no's in the query

 

[John Spencer (MVP)]

Not that I know of. You could do this in a report using some code to change the
labels on some unbound controls, but I cannot think of a way to do this in a query.