Best Way to Exclude Null Data from Rows

  • Thread starter Thread starter cstclair
  • Start date Start date
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
 
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.
 
Back
Top