Chart Showing Detail of Records

[jamiers]

Hello All,

I know that it is Thanksgiving in the US, but I am hoping that someone can help me out! I am a teacher. I have created a database of student quiz scores. I am using Access 2003. What I would like to do is create a line graph including date and score in a report. Unfortunately, I can't get the scores to show up in the data portion of the graph of the report. Is there anyway to have a subtotal, then have the details section ... place a graph in the detail section and graph the individual scores for one student?

I know how to subtotal/group out the individual students, I just can't get the proper scores to come up on the graph...

Anyone have any ideas? I know this isn't the most articulate post. I am pretty well-versed in creating queries and reports... I just have never tried inserting a graph/chart into a report before.

Thanks... Jamie

 

[jamiers]

I tried to find a way to edit my original post. I might be missing it, but I can't find a way to edit! I have attached two files so you can see what I want.

The report should look like the PDF. I have provided a screen shot of my query so you can see the info.

http://drop.io/jamieaccess