Help with Line Chart

  • Thread starter Thread starter Guest
  • Start date Start date
G

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;
 
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
 
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
 
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
 
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
 
Back
Top