Tek-Tips is the largest IT community on the Internet today!

Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!

  • Congratulations strongm on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!

Selecting records based on blank field 1

Status
Not open for further replies.

kemmm

Technical User
Jul 18, 2005
1
US
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?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top