Conditional printing of fields in a report

[Jodith]

I have a personnel database that I created. One of the tables tracks
information in the personnel file. I am trying to come up with a report that
will print out any information that is currently not in compliance. I know I
can use IIf statements to calculate whether each field is in compliance, but
how do I tell it not to print fields that are in compliance. We've got about
25 fields that we have to track for various state contracts, and I'd like to
not have to use a full sheet of paper for each employee (what can I say,
we're a poor non-profit).

Any suggestions on how to set this up short of writing scripts, which would
make definitely make my head explode?

 

[Matt Wickham]

You can use two separate strategies. First use IIF to create null fields,
and then concatenate them all into one giant field using & and separate by
commas. Next, for multiple vertical lines, set the
"Can Shrink" property in the field to Yes. Access will suppress lines that
are blank with this property. Something like this: Giant txt box:

=IIF([Field1] not = criteriaForSuppression, [Field1], "") & ", " & ([Field2]
not = criteriaForSuppression, [Field2], "") & ",".....

 

[Jodith]

Thank you, thank you, thank you! That's absolutely perfect!