Report generating too many records 1

[laina222]

I have a report I created and I set it up so I'd have one record per page, but really since the report is two pages per record, it's one record per two pages.

So I was testing the report and now where there are only two records to report on, it's generating multiple duplicates of these records! For example, EmployeeID 345 should take up pages 1 and 2, but it's taking up pages 1-34. If there are two records in the report, record 1 is pages 1-34 and record 2 is pages 35-68. How do I stop this???

Thanks in advance!

 

[Trendsetter]

Examine the query that is populating the report.
Run the query without the report and see if you get multple entry of the same data or more reported instances than really exist.

If this is the case you have an error in the tables links and you are generating a circular reference.

Frank J Hill
FHS Services Ltd.
frank@fhsservices.co.uk

 

[laina222]

You were right! That's funny, because the first time I ran it it was fine...that's Access for me, I guess. Thanks