Get rid of 0's (zeros)

T

Timothy.Rybak

Hey everyone...

I have a table of data with a few columns...date, part A, part B, part
C. The table has null values for days when no data is collected.

I created a simple query to that gives me the total number of parts
(the sum of A, B, and C) for each date. To get at this, I had to use
the Nz function to overcome the null values.

Now, I am trying to create a line graph to show trending. However,
because of the 0's that my query created (from using Nz), my line graph
is graphing all of these 0's.

Is there any way to have the 0's ignored, or a way to do my query so
that I don't have to use Nz?

Thanks!
Tim
 
Top