Reports duplicating information several times

[Guest]

I have been developing a database with Access. I have a number of calculated
fields; DCount, totals, Comparisons between DCounts, etc. My problem is that
the first time I printed the report it had the information correct and only
one time. After entering test data, I am getting correct information, but
several times over several pages. I have set the hide duplicates property
for all of my calculated fields.

 

[Pat Hartman\(MVP\)]

You have a query that joins tables with a 1-many relationship. It is best
to use a main report for the 1-side data and a subreport for the many-side
data. That will prevent your counts and sums from being thrown off. Once
you split the report, make sure to remove the many-side table from the main
report's query.