Query Criteria Results

T

TAWise

I have a query with many fields but I want the output to show only those
records that have data in one of the fields. If this particular field is
blank, I do not want the query to show that record.

Thank you.
 
J

Jerry Whittle

In the criteria for that field put the following. It takes care of Nulls,
zero length strings, and spaces all which can be construed as blank.

Is Null Or "" Or Like " *"
 
Top