Best Way to Exclude Null Data from Rows

[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

 

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

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