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

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.
 
A

Allen Browne

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Suppress printing of value after it has first appeared. 2
How to Suppress Report Line Containing Label But With Blank/Null D 2
suppress printing line in report 10
Suppress page break if subreport has no data 1
How to suppress printing a record? Access2007 2
Suppressing particular detail lines for blank data 3
Printing xxx.xx but not 0.00 in reports 3
Suppress a report page if a subreport contains no data 1

Top