Report only Null valuses

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

Guest

I have a program that has 14 variables (Yes/No). If they are checked they
should not show up on the report. If they are not checked I would like to
report it.
Say ... Classes MS Access, MS Excel, MS Word and MS Excel is not checked ...
I would like the report to show Mr. Smith then list Classes Needed MS Excel
as it was not checked as being completed.
 
Sounds like a design issue. This seems more like a one-to-many
relationship. You should create a record in a separate table only for the
classes the person has taken.

But, if you want to stick to your design, then just put criteria in your
query under each of those fields...

=false


Make sure to put the criteria on a separate line for each field. That
creates an "OR" condition.

Once you do that, the query will pull any record where there is at least one
unchecked value.
 
Back
Top