Chart with data from two different tables?

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

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
 
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
 
Back
Top