produce a report in Access which ignors records with empty field

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a database with several fields, one of which is empty for some
records. I want to be able to produce a report which displays the
information for all records which have text in the particular field and
ignors records for which there is no text in that field.
Reading help etc, it seems pretty straight forward, but I just can't seem to
get it right.
 
Nobby:

In the report's underlying query, add a condition on the field in question.
That condition should be:

Not IsNull

If it is a text field and there is the possibility of zero length string
data in the field (check the field properties in the table to see if it
allows zero length) you may also need to add a field to the query like this:

ChkZLS: Len([YourFieldsName])<1

with a condition of: True
 
Back
Top