Report

N

neha

I have a report based on a query Where Field 'Report
requested'is "Yes".For all these selected records I want
to show 'Name of Organization' only if it is not the
Organization named "ABC" .In that case it should show the
record with all other fields , but keep this field blank.

How do I do this?
Thanks.
 
F

fredg

I have a report based on a query Where Field 'Report
requested'is "Yes".For all these selected records I want
to show 'Name of Organization' only if it is not the
Organization named "ABC" .In that case it should show the
record with all other fields , but keep this field blank.

How do I do this?
Thanks.
Click to expand...

Use an unbound control in the report.
Set it's Control source to:
=IIf([Organization]="ABC","",[Organization])
 
Top