Placing Charts in MSAccess

[sandet]

I need to create a chart in Access that compares input to output. It looks great in design view, but in print preview, the information is completely different. I tried to print it and it prints what's in print preview. Please help!

 

[Bru]

Are you using insert chart for the control?

I had this problem as the chart used all the info in the tables instead of the relevant records for the report. This is the sql text from the statement in select row property in the properties Data section. The tables held
test information as a parent table, and data in a child table, distance and resistance.

SELECT FOPDataforgraph.Distance, Sum(FOPDataforgraph.Resistance) AS SumOfResistance
FROM FOPDataforgraph
GROUP BY FOPDataforgraph.Distance, FOPDataforgraph.HeadID
HAVING (((FOPDataforgraph.HeadID)=[Forms]![Findrecordbycust]![Text28]));
As you can see, I used a form to find and launch the report. This is one solution, but I found that I had to define the row source beyond where I thought that the link wizard would take it.

Hope this helps