Graphing data from multi queries...

[Jason S.]

Is this possible. I cannot seem to find any info in the
help. Ive got several queries that count the ammount of a
condition:
AI
LD
EI
CI
etc... I would like to make a pie graph showing all of
the data...
Ive got each condition in its own query. Is that my
problem? I cannot seem to join them into one query.
Jason

 

[SA]

Jason:

Use what is called a Union query. Of course you have make sure all the
columns are equal between the queries so you'd have something like this:

Select AI, 0 as LD, 0 as EI, 0 as CI from MyAI query
Union Select 0 as AI, LD, 0 as EI, 0 as CI from MyLD query
Union Select 0 as AI, 0 LD, EI, 0 as CI from MyEI query etc.

Then create a group by query using the MAX for each field based on the union
query.

 

[J Sines]

I guess Im new to union queries. Would I make a new query
then and union query them or add a union query into the
multiple other queries?

Is there a good resource I might look up to learn more?

When you say select AI, 0 as LD, O as EI, etc. Do you
mean to do that in the Criteria of the colum? or make new
colums.
Jason