Best Way to Exclude Null Data from Rows

C

cstclair

Hello. I have a comparison query that compares sales
data related to customers for two different periods. My
problem is that we have quite a few customers that buy
just a few times a year. So, I have this report that
prints quite a few pages of customers with no activity.
Is there a way to suppress the customers that have no
activity for both periods being compared? Thanks in
advance.

Chris
 
J

John Vinson

Hello. I have a comparison query that compares sales
data related to customers for two different periods. My
problem is that we have quite a few customers that buy
just a few times a year. So, I have this report that
prints quite a few pages of customers with no activity.
Is there a way to suppress the customers that have no
activity for both periods being compared? Thanks in
advance.
Click to expand...

Sure; just use a criterion of IS NOT NULL on the relevant field in the
query.
 

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

Simple way to combine unmatched and matched records in one query? 6
Combine all records from two tables to include related and unrelat 1
Working on birthday "book" for my wife and having layout/editing trouble 0
3 day 2 night Travel Certificates. Only 0.35 cents each 1
data from multiple files: best way to extract 1
How to control how much gets printed (prevent printing blank rows) 2
How to count but exclude overlapping data 1
Working with Null Values 4

Top