Selection criteria to find null fields

[mps0]

I have a table with names, addresses, etc. Some of the records are missing ZIP codes, phone numbers, etc. How do I do a selection criteria to just show me the records with a null value in a particular field?

 

[stormtrooper]

Put into select expert:

isnull({your_field})

 

[synapsevampire]

I'd limit the rows returned to those that are empty (empty being just as important as null, as a field might have contained data and then been manually replaced using the delete key or using spaces, rendering it blank, but not null).

Under the Report->Edit Record Selection->Record, add in something like:

isnull({MyTable.MyZip})
or
{MyTable.MyZip} = ""
or
isnull({MyTable.MyPhone})
or
{MyTable.MyZip} = ""
etc...

This will limit the rows returned to ONLY those that are empty or NULL. You might even add in a trim function...

-k

http://www.informeddatadecisions.com

kai@informeddatadecisions.com