Help with Line Chart

[Guest]

Looking for a little help with creating a line chart in a report. The chart
will be used to show Rate of Penetrations (ROP) on the Y-axis at a specific
depth on the X-Axis. I have the chart set up but I can not figure out how to
make the query so the graph only displays data for the individual hole. I
would like to have the report display one chart per hole.
Sample of data
HOLE DEPTH ROP
A3 0 4.21
A3 1 2.068
A3 1.43 2.26
A4 0 312.5
A4 .82 437.5
A4 1.64 437.5

Current SQL statement for the chart
SELECT penetration.hole, penetration.length, penetration.rate
FROM penetration;

 

[Guest]

You can create a record source for your report that has one record per unique
hole. Then use the Link Master/Child properties of the chart control like you
would a subreport or subform. There is a sample of this at
http://www.access.hookom.net/Samples.htm.

 

[Guest]

Duane
Thanks for the help. I am half way there by using the link Master/Child I
was able to make it so each of the line charts shows only teh data that is
relevant to that particular hole. The problem I am having is that I am still
getting a chart for each record that I have in the table. If I have two hole
I would only like to see two line charts. Presently I am getting 100+ Charts
for each hole.
Once again thank you for all of your help.
Cheers
Tim

 

[Guest]

Go back and read the very first sentence of my previous reply.

 

[Guest]

Duane,
More of a newbie than I thought, I am not sure how to do that. All of the
data that is in the tbl is being imported from an XML file that I do not have
control over. The only thing that I can think of is to create a qry as the
record source but I am not sure how I could get one record per unique hole. I
would just liek to use the hole# as the unique identifier.
Thank you,
Tim

 

[Rob Parker]

Try:
SELECT DISTINCT hole FROM penetration;
as the query on which your report is based, and retain your existing query
for the charts themselves.

Rob

 

[Guest]

Rob and Duane,
Thank you both for your help. It is all working correctly now. I really do
appreciate all the help the volunteers put in here.
Cheers
Tim