Report chart problem

[Jellyhawk]

Hello again everyone,

I have been using access for a couple of months and I think I am starting to get the hang of it, well nearly.
Anyhow my current problem is with regard to charts.

I have a report based on a query. I have set up a chart which totals up some costs and displays them in a bar chart against the year at which they are projected to occur. The chart works fine with one minor flaw.
When I preview the Report it produces a chart for every record giving me 50 odd pages. Is there a way I can produce a report with just one chart based on the fifty records? I used the chart wizard to produce the chart and I may have missed a trick along the way.

Any help is appreciated,

Many thanks,

Kev.

 

[Jellyhawk]

Nevermind,

I found the answer in another thread by re-wording my search of these forums.

Thanks again.

Kev.