Two queries, one graph

[LV]

I want to display a graph that pulls data from two different queries, but am
struggling to get the Row Source info correct. Here's what I have:

SELECT [Hours],Avg([Dp]) AS [AvgOfDp],Avg([etoh]) AS [AvgOfetoh] FROM [data
drop], UNION, SELECT [Hours],[Dp],[etoh] FROM [graph data];

I want to pull Hours, Dp, and etoh (as averages) from the "data drop" query
and Hours, Dp, and etoh from the "graph data" query. I tried "marrying" the
two queries with a "UNION" command, but no luck.

How can I get this data in to one graph???

Thanks in advance!
--

 

[Jack Cannon]

A UNION query will only display the data as separate graphs which forces you
to move to the next row to view each independently.

A SELECT query will work if you join [data drop] to [graph data] (probably
an INNER JOIN).
That will get all your data on the same row thus allowing you to design the
graph accordingly.

Jack Cannon

 

[Douglas J. Steele]

What does "no luck" mean in this context?

The UNION query you've presented is invalid syntax. There should be no
commas on either side of the keyword UNION.