Making One Chart

[Nicole]

I want to make one chart that represents info from all of my records. I can
figure out how to insert a chart into a report, but there is one report per
record. This is great, but I only need one chart, not X number of charts.
How do I set up an environment that will allow me to have only one chart.
The only options I see are to install a chart into each form record or
report. Thanks.

Nicole

 

[Al Campagna]

Nicole,
Sounds like you have the chart in the Detail section along with your data. Move it
into some others section, like the Report Footer. The query behind the chart should be
similar to the query behind the report itself. The Detail section displays all the
records, and the Report Footer contains the chart of all the record values.

--
hth
Al Campagna . Candia Computer Consulting . Candia, NH USA
Microsoft Access MVP
http://home.comcast.net/~cccsolutions

"Find a job that you love, and you'll never work a day in your life."