Forum Discussion
Access report repeating to multiple pages
The problem is, most likely, in the query which provides records for the report, so we need to start with it.
Open that query. Does it return hundreds and hundreds of records? My guess would be that it does.
Explain, in a narrative, the goal you want to achieve.
Also, show us the SQL from this query. A screen shot of the Query Designer is okay, but the SQL is more useful.
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#));- You posted only the group by and having clauses. That's not the entire SQL, which is what I meant.
I echo Tom's question as well.
When I asked for a narrative, I was hoping for an explanation of the purpose for the report. Why do you want to display this data? What does it represent? That sort of thing. Help us understand the context. - 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?
Tom_van_Stiphout it's a typo. Please read date received as date decision received
