Yes/No Query?

  • Thread starter Thread starter Code Agent
  • Start date Start date
C

Code Agent

I have a table that has numerous fields that use the yes/no function. How do
I run a report to only show the fields that have the value of yes?
 
Code Agent said:
I have a table that has numerous fields that use the yes/no function.
How do I run a report to only show the fields that have the value of yes?
Click to expand...

So you want to show a checkbox on the report in that column if the field is
Yes, but leave the column blank if it's not? If that's the idea, you can
use a text box to simulate a check box, and just use a space for No. Here's
how:
Format check boxes in reports
at:
http://allenbrowne.com/ser-52.html

In general, having lots of yes/no fields in a table is not a good database
design. It may be better to have a related table where you enter a record
for each option that applies, rather than try to put a checkbox for each
option in your table. Details in:
Don't use Yes/No fields to store preferences
at:
http://allenbrowne.com/casu-23.html
 
Back
Top