listing Null as off

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
 
K

Ken Snell

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.
 
W

Warren Kelley

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.
 
K

Ken Snell

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])
 
Top