Chart prepared from a query appears blank.

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Earlier the Chart used to plot fine with the same query. We recently added
data to the database, and since then we recd a message" Data Mismatch
Criteria". and ever since then if I try to plot the chart using that query,
it just comes up blank.
Please Help!!!!!
FC
 
What have you done to troubleshoot? Have you looked at recent records to
search for nulls or zeros? Have you attempted to limit records in the row
source to the point where it works again?
 
I have checked for Nulls, Zeroes or Errors, and elliminated them.Earlier it
would plot the chart for the year 2004 from Jan to July any data entered
after that has blanked it out. Although the database has data for 2003 ans
2004, the query has data only for 2004 and from that the plot is done. How do
I get to the row Source to limit records?
 
The Row Source is a query. You limit records in the same way you limit
records in a query output. Can you share the SQL of the Row Source?

I really expect that something in your query (possibly) a join is causing
the error. Since we can't see your query or your data, you have to do some
troubleshooting to rule out some possibilities.
 
Back
Top