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 Chris Miller on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
How do I write a Query that will search for blank descriptions?
- Thread starter tthai826
- Start date
Under report, edit selection formula, record write a formula like the following:
IsNull({DescriptionField}) or Length(Trim({DescritionField})=0
I always test both for null and length()=0 as I have had some mixed results simply testing for nulls. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
IsNull({DescriptionField}) or Length(Trim({DescritionField})=0
I always test both for null and length()=0 as I have had some mixed results simply testing for nulls. Software Training and Support for Macola, Crystal Reports and Goldmine
251-621-8972
dgilsdorf@mchsi.com
- Thread starter
- #3
- Status
Similar threads
- Locked
- Question
- Locked
- Question
- Locked
- Question