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