listing Null as off

  • Thread starter Thread starter Warren Kelley
  • Start date Start date
W

Warren Kelley

Hello all

I am having a problem with a query

The system that we are using to export data is exporting Null fields as Off
How can I mask the query to show off as null and if possible on the report
to show nothing at all.

thanks
 
Post an example of the data records that you are receiving and that have Off
(the word? A value of 0? the boolean value of False?) in the data.
 
the export program (acrobat) is placing the Nulls as OFF

so the example would be in delimited

"1","4","04","OFF","OFF","Capital"

In the report it shows the Off and we want the Query or report to show them
as NULL or nothing. and we need the complete string.
 
Use a calculated field in place of the real field, and use an expression
similar to this for that calucated field:

ReplaceField: IIf([RealFieldName]="OFF", Null, [RealFieldName])
 
Back
Top