Report Charts

S

Sarrina

I am trying to create numerous (repeating design) charts
in my report. The problem is that Access seems to be
trying to gain ALL information throughout the report
rather than each section.

What I am doing is:

[Contents] Claim #, Monitoring Well, Date, Benzene Sample
Level

[Report Design]

30000
Monitoring Well 1
01/01/90 11.357
03/01/90 12.832
07/03/91 9.573
08/15/93 11.756
04/16/94 10.375

Monitoring Well 2
03/01/90 10.832
07/03/91 7.573
04/16/94 14.375

Monitoring Well 3
01/01/90 13.357
03/01/90 11.832
07/03/91 9.573
08/15/93 7.756
04/16/94 5.375


30050
Monitoring Well 1
So on and so forth


(Each claim has different numbers of Monitoring Wells, and
each claim may label their wells differently (RW, RS, 1 2
3 4, WO, etc.) If there is no data for a claim - then I
would like for the chart to appear (blank or otherwise)
for that claim.

______________________________________________________

I am telling Access to place the chart in the design view
under the "Monitoring Well Header".

The information that I want charted for each claim would
be the level of Benzene (Y axis or Data) to the date (X
axis or Axis) for each monitoring well.

The second report I will need the charts for each claim -
Level of Benzene (Data), Date (Axis), Monitoring Well
(Series).
_______________________________________________________

I have tried different ways to plot the information for
the chart, but it is still not recognizing what I want it
to do.


HELP!
Much appreciated.
Sarr
 
Top