Forum Discussion
Access report repeating to multiple pages
I have put together a report in access and it is a summary of count from the query result but the table is repeating 100s of pages as you can see in the picture. Can anyone please let me know how to...
There seems to be some sort of glitching in the forum software. Originally I thought I saw the entire SQL, but now only part of it is in your post.
George_Hepworth please see a sample db with the same issue in the report
- Thank you.
The report produces the exact results one would expect, based on the query and the way the report is designed. What, exactly, DO you want it to look like?George_Hepworth Thanks, if you see the report it is repeating to multiple pages and I want it to be just one pages.
- But that's exactly what this report is designed to do. You have multiple records in the query. The detail section is repeated in the report for each record, over and over and over, and that will eventually create multiple pages as well.
What DATA do you want to display? Please explain, in words, what it is this report is supposed to tell you.
The query itself has a Group By clause, which includes every field in the query. That means it will group on each record, so it is totally ineffective. If you actually do want some sort of grouping, please include that in your explanation.