Repeating Report

[Red via AccessMonster.com]

Hi all,

Can anyone suggest what I can do to stop my report repeating itself? I have
my information, 8 lines that keeps duplicating itself for 5 pages. I only
need to see it once, not 25 times. I know I haven't provided much technical
information on this but I've never seen this before and hard to explain. Any
suggestions would be greatly appreciated.

VR,

Red

 

[Red via AccessMonster.com]

If it helps anyone, I have a bit more information but not sure if it is
helpful. I am getting exactly 14 copies of the information and I have 14
entries in the table the report is based on. Not sure if its coincidence or
not.

Thanks for any help.

VR,

Red

 

[fredg]

Hi all,

Can anyone suggest what I can do to stop my report repeating itself? I have
my information, 8 lines that keeps duplicating itself for 5 pages. I only
need to see it once, not 25 times. I know I haven't provided much technical
information on this but I've never seen this before and hard to explain. Any
suggestions would be greatly appreciated.

VR,

Red

I would suspect the query you are using as record source for this
report has data from 2 or more tables, and you do not have a
relationship between them (or at least one of them).
If so, establish a relationship between the tables.

 

[Red via AccessMonster.com]

Thanks for the reply...

I am pulling the data directly from a table not a query. I'm thinking I
might use a query as the data source rather then directly from a table. Is
this my problem?

Thanks,

Red

Hi all,

[quoted text clipped - 7 lines]

Red

I would suspect the query you are using as record source for this
report has data from 2 or more tables, and you do not have a
relationship between them (or at least one of them).
If so, establish a relationship between the tables.