This is a really weird problem:
I have a report that generates a graph from a query (acutally, I have several). Most of the time, if there is no data to generate the graph for the given parameters, it will return an empty graph. About one time in ten, however, that graph will return with phantom data. I have no idea where it's coming from or what, and running only the query will only ever return an empty table on the same parameters. Namely, this problem is not caused by the query being screwed up, because it always works.
Whenever I try to print one of the graphs with phantom data, it spits out an empty graph, like it should have displayed, as if what is on the screen is not actually there. The only answer I could possibily think of would be an error in the way pointers are being handled (incremented, etc) in Access itself.
This is without doubt one of the strangest things I've ever seen - any advice/experience with this?
thanks,
Neil
I have a report that generates a graph from a query (acutally, I have several). Most of the time, if there is no data to generate the graph for the given parameters, it will return an empty graph. About one time in ten, however, that graph will return with phantom data. I have no idea where it's coming from or what, and running only the query will only ever return an empty table on the same parameters. Namely, this problem is not caused by the query being screwed up, because it always works.
Whenever I try to print one of the graphs with phantom data, it spits out an empty graph, like it should have displayed, as if what is on the screen is not actually there. The only answer I could possibily think of would be an error in the way pointers are being handled (incremented, etc) in Access itself.
This is without doubt one of the strangest things I've ever seen - any advice/experience with this?
thanks,
Neil
