how to make pivotchart based on 2 queries

[Guest]

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??

 

[Douglas J. Steele]

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

 

[Guest]

can you Explain plzz

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

 

[BruceM]

I don't know that I fully understand your requirement, but this article may
provide useful information:
http://support.microsoft.com/kb/304458/en-us

 

[Guest]

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