How to suppress printing reports that contain no data is select fi

  • Thread starter Thread starter Herb
  • Start date Start date
H

Herb

How can I suppress printing reports that contain no data is select fields? I
have tried to suppress printing by modifying conditions in my query to "Is
not Null". This works when it applies to only one attribute. However, when
applied to multiple attributes, it will not work.
 
In query design, underneath the row marked "Criteria", you will see several
rows marked "Or". Try placing your Is Not Null on different rows, under the
different fields.

If you have several similar columns (such as Product1, Product2, ..., or
Week1, Week2, ...), the real problem is with the way the table is designed.
You need these as several *records* in a related table, instead of several
columns in this table. That way, the problem of columns that have nothing in
them evaporates.
 
Back
Top