Blank Fields

[NBS]

Hi, I was wondering if there is a simple solution to this problem:

I am using the Select Expert to extract all records that do not contain 4 particular things in a field called key5. It runs fine excluding the data that I want to filter but does not give me records with no data in that field. I would like it to include those records however. If anyone could help I would appreciate it.

Thanks, J

 

[kenhamady]

You need to use:

IsNull ( {field} )
or
....(your existing formula) Ken Hamady

http://www.kenhamady.com/

On-site custom Crystal Reports Training and Consulting.
Quick Reference Guide to using Crystal in VB.