Reports repeating information several times

[Cassi]

I have been developing a database for our organization. i have set up a
report with calculated fields including; DCounts, Comparisons between
DCounts, Totals, etc. The problem is although I am getting correct
information, it is being repeated several times over several pages. I have
set the hide duplicates property on all of the text boxes.

 

[Marshall Barton]

I have been developing a database for our organization. i have set up a
report with calculated fields including; DCounts, Comparisons between
DCounts, Totals, etc. The problem is although I am getting correct
information, it is being repeated several times over several pages. I have
set the hide duplicates property on all of the text boxes.

The repetitions are probably coming from the records in the
report's record source table/query. Examine the data set
that the report is processing to see if you can see how to
get rid of the extra records. If the report is doing
everything with calculations, maybe the report should be
unbound??

 

[Cassi]

The record source for this report is one table and four queries. there
should be no duplication from the tables because the report is all calculated
fields and labels. I am not sure I know how to make the report unbound.
Most of my textboxes are unbound.

 

[Marshall Barton]

The record source for this report is one table and four queries. there
should be no duplication from the tables because the report is all calculated
fields and labels. I am not sure I know how to make the report unbound.
Most of my textboxes are unbound.

Try opening the record source query from the query design or
database window and check the query's dataset carefully.