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

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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
 
Back
Top