If Statemen t

  • Thread starter Thread starter Alex H
  • Start date Start date
A

Alex H

Hi,

I have a report containing a field [criteria], which is also the control
name.

What I am trying to do it to set this so that if the field [criteria]
contains "No Response", it dispayes nothing, else it dispays whatever is in
the field. I am using the following syntax, which is returning an error

=IIF([criteria]="No response","",[criteria]

Can someone tell me what I've done wrong

Than ks

Alex
 
Thanks Randy

A

Randy Armstrong said:
Your control needs a different name than your field name.
-----Original Message-----
Hi,

I have a report containing a field [criteria], which is also the control
name.

What I am trying to do it to set this so that if the field [criteria]
contains "No Response", it dispayes nothing, else it dispays whatever is in
the field. I am using the following syntax, which is returning an error

=IIF([criteria]="No response","",[criteria]

Can someone tell me what I've done wrong

Than ks

Alex


.
Click to expand...
Click to expand...
 
otherwise you need to fully qualify the names

Alex H said:
Thanks Randy

A

Randy Armstrong said:
Your control needs a different name than your field name.
-----Original Message-----
Hi,

I have a report containing a field [criteria], which is also the control
name.

What I am trying to do it to set this so that if the field [criteria]
contains "No Response", it dispayes nothing, else it dispays whatever is in
the field. I am using the following syntax, which is returning an error

=IIF([criteria]="No response","",[criteria]

Can someone tell me what I've done wrong

Than ks

Alex


.
Click to expand...
Click to expand...
Click to expand...
 
Back
Top