Selecting records based on blank field 1

[kemmm]

I simply want to create a list of employees for my company that shows who has not enrolled in health insurance.

How do I set my selection criteria for an empty field?

 

[synapsevampire]

Please remember to include basic technical information, such as the version of your software and the type of field.

There are 2 possibilities, a null field or a blank field.

I'll give an example for a field that would contain a Y or N in an alpha field

Go to Reports->Edit Selection Formula->Record and place:

(
isnull({table.field})
or
{table.field} = ""
or
{table.field} = "N"
)

This would check for it being either a null, or blank, or contain the letter N, adjust as required.

Note that your lack of information degrading the quality of the response, as with most 1 or 2 line posts.

Successful posts tend to include:

Crystal version
Database/connectivity used
Example data
Expected output

-k