Eliminating N/A Values from Detail Section in a report

B

Bill Geno

Hi,

I have a report where it simply lists detailed records. One of th
columns is entitled Certifier, and this is column in the query. Th
query is returning records with Certifiers names as well as N/A in th
same column (data is fed in from another application--it sometime
registers N/A values when the Certification is created but there is n
certifier name).

I'd like my report to just include the records where there is
Certifier name present, and ignore the N/A's in the query. We want t
keep the N/A records in the query and source table. The field I a
interested in is Certifier.
I have tried [Certifier] <> 'N/A' which resulted in Error.
I have also tried IIf([Certifier] <> 'N/A', 0)) which is not workin
either.

Any suggestions? I just want to build a text box and control tha
eliminates the N/A's for the Certifier, but includes the records wher
there is a name populated.

Thanks much,
Bill
 
C

Carl Rapson

Bill Geno said:
Hi,

I have a report where it simply lists detailed records. One of the
columns is entitled Certifier, and this is column in the query. The
query is returning records with Certifiers names as well as N/A in the
same column (data is fed in from another application--it sometimes
registers N/A values when the Certification is created but there is no
certifier name).

I'd like my report to just include the records where there is a
Certifier name present, and ignore the N/A's in the query. We want to
keep the N/A records in the query and source table. The field I am
interested in is Certifier.
I have tried [Certifier] <> 'N/A' which resulted in Error.
I have also tried IIf([Certifier] <> 'N/A', 0)) which is not working
either.

Any suggestions? I just want to build a text box and control that
eliminates the N/A's for the Certifier, but includes the records where
there is a name populated.

Thanks much,
Bill G
Click to expand...

I'm assuming that the report is based on the query you described, and you
want the query to continue fetching records with [Certifier]='N/A', but you
don't want the report to show those records. How are you opening the report?
If you are opening it with DoCmd.OpenReport (from within a form), then you
can pass an additional WHERE clause in the OpenReport call:

DoCmd.OpenReport MyReport,,,"[Certifier]<>'N/A'"

This will further filter the query and eliminate those records.

HTH,

Carl Rapson
 
Top