how to make pivotchart based on 2 queries

J

Jon

hi,
I need to create a pivotchart based on 2 queries. The first query is for
inquiry about employee performance and the performance is 9 fields. And the
other one is for employee courses. This query look for employee course and
each employee has two courses
How can I do that please??
 
D

Douglas J. Steele

Have you tried creating a query that joins your two existing queries, and
creating a pivotchart on that 3rd query?
 
J

Jon

can you Explain plzz

Douglas J. Steele said:
Have you tried creating a query that joins your two existing queries, and
creating a pivotchart on that 3rd query?
 
J

Jon

yes, they are. the new data entered can not be updated until closing the
orginal form an open it again
 
Top