Graphing data from multi queries...

  • Thread starter Thread starter Jason S.
  • Start date Start date
J

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