Chart with data from two different tables?

[Toan Chau]

Hi.

Is it possible to make one graph based on two different
data set from two different queries?

Currently I 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 on the same graph?

I am using Access 97.

Thanks!

--Toan

 

[Pavel Romashkin]

Maybe, you can base the chart on the data from both queries joined
inside a third query?

SELECT Q1.*, Q2.* FROM Q1 INNER JOIN Q2 ON Q1.x_axis = Q2.x_axis

Pavel