If Statemen t

[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

 

[Randy Armstrong]

Your control needs a different name than your field name.

 

[Alex H]

Thanks Randy

A

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


.

 

[Marty L]

otherwise you need to fully qualify the names

Thanks Randy

A

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


.