Forum Discussion
Libin7963
Nov 10, 2023Copper Contributor
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...
Libin7963
Nov 10, 2023Copper Contributor
Tom_van_Stiphout it's a typo. Please read date received as date decision received
George_Hepworth
Nov 10, 2023Silver Contributor
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.
- Libin7963Nov 11, 2023Copper Contributor
George_Hepworth please see a sample db with the same issue in the report
- George_HepworthNov 11, 2023Silver ContributorThank 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?- Libin7963Nov 11, 2023Copper Contributor
George_Hepworth Thanks, if you see the report it is repeating to multiple pages and I want it to be just one pages.
- Libin7963Nov 10, 2023Copper ContributorSELECT TableNameA.Reference, TableNameA.Receiveddate, TableNameA.DATEAPVAL, TableNameA.Datedecision received, TableNameA.DTYPNUMBCO, DateDiff("ww", [DATEAPVAL], [Datedecision received]) AS TATS
FROM TableNameA
GROUP BY TableNameA.Reference, TableNameA.Receiveddate, TableNameA.DATEAPVAL, TableNameA.Datedecision received, TableNameA.DTYPNUMBCO
HAVING (((TableNameA.Receiveddate) > #1/1/2020#));- XPS35Nov 10, 2023Iron Contributor
Libin7963 I don't think this is the full story. This query won't produce the output presented in your first post. Please explain how the output is generated. Or post a copy of your database.
- Libin7963Nov 10, 2023Copper ContributorTATS is a column with Expression to find the date diff. between date decision received and receiveddate