you should be able to embed the report at each area and supply appropriate data. what have you tried to date
one thing I would take issue on with the "sparkline" approach is that the graph may lead to the wrong statistical impression, as there seems to be no reference to the base value.. 0. but thats just my bugbear.
if you cannot get the chart to work then maybe you need to think about writign an OCX or user control.. that should get some extra credits.
Hi. I have tried adding the chart. I can get it to the point where it places the appropriate number of chart controls on the report, but only places a bound chart in the first position (record). Adding charts to reports in Access is new to me and maybe I am missing something here.
The sparklines themselves are really valuable and I enjoy how they speak to the trend. If I can get this idea to work I will place a field beside each chart/sparkline to show the current value of the record.