how to make pivotchart based on 2 queries

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Jon - 07 Aug 2007 12:00 GMT

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

Reply to this Message

Douglas J. Steele - 07 Aug 2007 12:36 GMT

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

Signature

Doug Steele, Microsoft Access MVP
http://I.Am/DougSteele
(no e-mails, please!)

> hi,
> I need to create a pivotchart based on 2 queries. The first query is for
[quoted text clipped - 3 lines]
> each employee has two courses
> How can I do that please??

Reply to this Message

Jon - 07 Aug 2007 12:50 GMT

can you Explain plzz

> Have you tried creating a query that joins your two existing queries, and
> creating a pivotchart on that 3rd query?
[quoted text clipped - 6 lines]
> > each employee has two courses
> > How can I do that please??

Reply to this Message

BruceM - 07 Aug 2007 13:13 GMT

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

> can you Explain plzz
>
[quoted text clipped - 10 lines]
>> > each employee has two courses
>> > How can I do that please??

Reply to this Message

Jon - 07 Aug 2007 17:04 GMT

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

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

Reply to this Message