Reports repeating information several times

G

Guest

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.
 
M

Marshall Barton

Cassi said:
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??
 
G

Guest

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.
 
M

Marshall Barton

Cassi said:
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top