print fields based on conditions/criteria

[DEmmett]

I want a report to print only fields from a query that meet certain criteria,
ie notnull, greater than 3, etc. I thought using conditional format, but I'm
not sure how. Since many fields have different values, I can't just do a
simple if Null... Bottom line:
I am attempting to create a report that shows delinquent training for
employees. I am not interested in the 110 areas they are current in, I need
to see the 3 areas they are delinquent in.
I suspect after I figure out the condition issue, how do I do the
concatenate? do I have to list each field in the statement?

 

[RBear3]

First, it sounds like your table is not built properly. If you have 110
fields in a table and each field is named after a class or program that the
user must complete, then your table is not normalized. Any time your field
names include data (Orientation Class1, How to use Email, etc.) then you
have a non-normalized table.

Instead, you should have a table for your people, a table for available
classes, then a table where you add a record for each class that a person
took. You may need some more complex logic if the desired classes vary
based on the person's department or job class. This might involve one more
table in the mix.

Once you have normalized your data, then you will have to create some type
of unmatched query to pull classes that have not been taken.