Can I make a query that only displays fields with "yes" response?

O

oharring

I'm trying to create a query that pulls information from a table that's just
a person's name followed by a number of yes/no fields. I'd like for the query
(or an associated report) to display the person's name and any fields which
contain a "yes". ANy bright ideas?
 
D

Duane Hookom

I think the brightest idea might be to normalize your table structure. I am
only guessing that your table structure might not be conducive to this type
of display on your form or report.

We might understand better if you provided
1) table structure
2) sample records
3) desired display in your form or report
 
Top