Hi everybody! as all of us who work with the MSChart control know, it has the nasty habit of displaying false data when none exists.

Currently I have a MSCHart control and a set of ADO recordsets to allow users to filter and graph information. The problem that I have is that when a user submits a query with multiple conditions and one of the conditions happens not to exist in the database, MSChart still shows information for it.

example

strQuery = "SELECT Name, Social_Status FROM Personnel WHERE Social_Status = "Single" OR Social_Status = "Divorced" ORDER BY Name"

will yield 2 columns titled "Single" and "Divorced." If the database contains no records where Social_Status = "Divorced", then rather than showing a column with a value of 0, the chart control throws some random number into the graph.

How can I stop it from doing this?

Thanks!

Andrew