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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

#error - Blank 3
export file lists Null as OFF 1
determining if a field should be included 6
Report has Null as off need it not to show 1
Query to text file cuts my leading zeros off. 4
counting Null fields 3
Windows 10 Error: 'CreateProcessWithTokenW' was not declared in this scope 2
Appending null data and moving! 4

Back
Top