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?

Status
Not open for further replies.

tthai826

MIS
Sep 24, 2002
18
US
What I'm basicly trying to do, is make a query that will search for part id's in the part master that have blank descriptions. I've tried several attempts concluding in failure. can anyone out there help me?
 
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
 
Status
Not open for further replies.

Part and Inventory Search

Sponsor

Back
Top