Populate Chart/Graph Using Report Fields

[Adam]

Group: I have a graph that was created from a query which pulls from
linked tables with ODBC. When I create a report, everything populates
correctly in about 10 seconds, but when I try to create a graph using
the same query, Access runs basically forever (over an hour) until I
hit <Ctrl><Break>. The issue seems to be with Microsoft's graph object
and ODBC, so my thinking is if I can create a graph utilizing the text
boxes in a report, then there won't be a link between the graph and
ODBC, only the graph and the report fields. Then I could make the text
boxes invisible.

My question is, is it possible to create a graph in Access that pulls
it's information from an Access Report's fields, rather than a query
or table?

 

[Guest]

There are a couple graphs in the sample at
http://www.access.hookom.net/Samples.htm that doen't use a chart control.