Report Detail repeating

[rloyd]

I am a very basic user. I created a report with a Page Header, a Group Header, Detail, Group Footer and Page Footer. The report is generating duplicate (4) detail lines of each record. This does not occur with every group but it is occuring with most groups. I have checked the integrity of the data and the data appears to be accurate.

Any suggestions?

Thanks you
RL

 

[csou5555]

Are you utilizing a query to generate the report? It sounds like you might have an incorrect join in a query, which can easily produce the type of error you are describing.

 

[rloyd]

I am not using a query to generate the report. The report is being generated using the report wizard pulling the information directly from the tables in the data base

 

[rloyd]

I have also run a query and the query returns the correct information without repeating any of the records. I then created a basic report using the report wizard pulling the information from the query and once again some of the records are repeated and some are not.

Any help is greatly appreciated.

RL

 

[csou5555]

That is very odd. Is there anyway you can post a sample mdb with the table(s), query, and report?

 

[rloyd]

I am a very basic user. Can you suggest how I can post the sample data base?

Thank you
Ron

 

[KeithG]

Go to post a reply and then to manage attachments. From here you can upload your file.