charts/graphs

  • Thread starter Thread starter Jack Gordon via AccessMonster.com
  • Start date Start date
J

Jack Gordon via AccessMonster.com

I have a report in Access97 that includes a line graph. The data for the
graph comes from a query which selects a subset of data from the original
table.

Randomly this graph will display lines for data that had been deleted weeks
prior. If the report is closed and reopened it displays the data that was
expected. If reopened again it sometimes will display the phantom data
again.

I checked, the data is definitely not in the table.

Does anyone have any idea what is happening?

Thanks.
 
are you caching the data in any form? it makes sense to purge the data from
the chart when the application is finished but unless you are maintaining
state somewhere, the data shouldn't show up again.

--
Regards,
Alvin Bruney
[Shameless Author Plug]
The Microsoft Office Web Components Black Book with .NET
available at www.lulu.com/owc
_________________________
 
Thanks for responding.
I'm not intentionally caching data. Is there some caching going on behind
the scenes? The phantom records are never visible on other reports, only
on graphs in reports. Could the sql statements used in the process of
gathering data for the graph be seeing records that were previously deleted?
If so, that would mean the select query would also be including the records.
 
Back
Top