All -
I am trying to track progress against a plan. It seems Access (2003) plots all points (even zeros, nulls, and "" Strings) as zeros for all dates. If you are 50% done with progress, your progress line(s) will take a "dive" and run along the x-axis to the last date.
Here's the $64 question: Who knows how to tell access to ignore the zero (or null) values? (See AccessChartIssu e.jpg for what I...
2 results in 0.0042 seconds.
-
How Do I Suppress Zeros in Access Pivot Chart?
Last edited by jbt007; Jan 25 '11, 08:03 PM. Reason: Shorten question to get some answers... I hope! -
Suppress records in Access
I would like to suppress a row of data if each of my 5 currency columns contains a zero. An example of 1 record is below:
So if columns 4 through 8 all contain zeros then I don’t want this record to appear in my report. I am not sure if this is even possible as I have been unable to find any documentation...Code:Col 1, col 2, col 3, col 4, col 5, col 6, col7, col 8 Smith, 2008, qtr4, 0, 0, 0, 0, 0
