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
Here is the query. Currently it returns 100s of lines but I limited the result to few lines yet it was not sucessfull. From the below query I am trying to make my result into a single page as summary such as - Items recieved for FY 2020, 2021 ..etc. which should ideally be only a single page as a summary.
SELECT 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#));
Tom_van_Stiphout
Nov 10, 2023Steel Contributor
The first thing I see that befuddles me is that your table apparently has 2 fields Receiveddate and Datereceived. Really? Aren't those two the same thing?