Venturing into the Access Charts danger zone. Why does chart appear on form once for each record?

[keun]

here is my data:

I am making a form which shows the data for each FirstName.

Here is the first record in the form:

The problem is the "Record: 1 of 6" - I expect there to be FOUR records, one for each person in my data. I am eventually embedding this data in a report grouped by FirstName and when I do that each chart shows up multiple times for each FirstName. In other words, since Mike and Lisa are in the underlying data twice, the chart shows up twice on their report section.

Is there a fix for this or something I am missing?

I thought about creating another query to Group the FirstNames and use that as the source for the Form, but I am not really sure how I would make that happen.

I joined this forum in 2005. I am still a hack.

 

[PHV]

Which data do you want for Mike and Lisa ?

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886

 

[keun]

The charts don't change. So the "Mike Chart" is the "Mike Chart" - the two iterations are the same. I just want one.

Here is a gif:

I joined this forum in 2005. I am still a hack.

 

[randy700]

Seems to me that, if you're basing your charts off a query that generates six rows, you'll have six charts.
If you want to combine the "Lisa" and "Mike" rows, your query will have to be modified.


Randy

 

[keun]

That seems odd... But let's say that's correct. I suppose the next question is how do I filter a chart to show only the data for one FirstName in such a way that I can drop it into a form or report which is grouped by FirstName.

I joined this forum in 2005. I am still a hack.

 

[keun]

OK, I fixed it. I created a Group By query with my FirstNames and I used that as the record source for the form. This allows me to cycle through FOUR charts.

My next problem is getting this to work on a complicated report with a bunch of subreports. Crossing that bridge soon.

I joined this forum in 2005. I am still a hack.

 

[randy700]

Answer PHV's question.
Which data do you want? You have 2 choices from your current query.

Perhaps if you post your query someone can help modify if.


Randy