Report

  • Thread starter Thread starter neha
  • Start date Start date
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.
 
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])
 
Back
Top