In the event that anyone finds this thread and is looking for the answer...
Both the main report and a subreport had a level of detail (multiple records)
where there should have been only one record. All the detailed information
was provided in the subreports and graphs.

--
Duane Hookom
Microsoft Access MVP


"Duane Hookom" wrote:

Email me directly at Duane at Hookom dot net to get instructions. Don't
email me your file until you hear from me how to do this.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

The prior emails have the record source code, as well as the row source code.
If you are receptive to it I'd be happy to .zip the file to you and direct
you to the problem I'm encountering.

Nate

"Duane Hookom" wrote:

I think your subreport is breaking down your records by Month or your main
report is breaking down records by month. I don't believe either of these
should be broken down to that detail level. Again, there is no reason to
display month information in the report just because you want something broke
down by month in the chart.

I still don't recall seeing the Record Source SQL of your main and
subreports, which section of the subreport contains the chart, and the Link
Master/Child of the Report/Subreport and Subreport/Chart.

--
Duane Hookom
Microsoft Access MVP


"ngincolorado" wrote:

How do I find out which is true?

"Duane Hookom" wrote:

Either your subreport prints multiple charts in each instance or your main
report has multiple instances of your subreport. Find out which is true and
correct it.

The subreport Record Source has little or nothing to do with the chart Row
Source. You might have only Year values in the subreport Record Source and
have Year and Month in the chart Row Source.

--
Duane Hookom
Microsoft Access MVP