One graph from two queries?

  • Thread starter Thread starter Toan Chau
  • Start date Start date
T

Toan Chau

Hi.

Is it possible to make one graph inserted into a form or
report that is based on two different queries?

Currently I only know how to get the chart to graph data
from one query. Can someone please advise me how to get
the second set of data from a different query on the same
graph?

I am using Access 97.

Thanks!

--Toan
 
You can graph more than one set of data on different scales but they should
have some common field value so the two queries can be combined into a
single query. You other option is to graph all the data without using a
graph control. You can use the Line and Print methods of the report to
create about anything you want. To see some simple applications of these
methods to create xy, line, and bar graphs, download the Corp Tech demos
from http://www.invisibleinc.com/divFiles.cfm?divDivID=4.
 
Back
Top