Multiple Parameter Chart

D

Dozer

Hi all!

I'm using Access 2K.

I have a parameter query which asks for Department and
then Site. The corresponding report returns the correct
data based on both parameters but the chart associated
with each record returned is not updating properly.

For example:

Record Data Chart Data
Dept A Site A Dept A Site A
Dept A Site B Dept A Site A
Dept B Site A Dept B Site A
Dept B Site B Dept B Site A

I can only get my charted linked by the first parameter
even though when I step through the wizard I specify both
parameters are needed to link the chart with the correct
record.

In the chart properties only the first parameter shows as
the linked field in the Child and Master. I tried adding
the second field manually but that produced incorrect
results.

Any suggestions......anyone, anyone??
 
Top