Access report repeating to multiple pages

[Libin7963]

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 make it to only one page. 

[#2]

@Libin7963 

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.

[#3]

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#));

[#4]

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?

[#5]

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.

[#6]

@Tom_van_Stiphout it's a typo. Please read date received as date decision received 

[#7]

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.

[#8]

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#));

[#9]

TATS is a column with Expression to find the date diff. between date decision received and receiveddate

[#10]

@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. 

[#11]

@Libin7963 Please don't crosspost without telling so.

Crossposted here 

[#12]

@XPS35 Please see attached database of similar issue. As you can see in the report page the data is repeating.

[#13]

@George_Hepworth  please see a sample db with the same issue in the report

[#14]

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?

[#15]

@George_Hepworth Thanks, if you see the report it is repeating to multiple pages and I want it to be just one pages.

[#16]

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.

[#17]

@George_Hepworth  sorry if I was not clear. It is this report that I don't want it to repeat as it is a summary from the Query1. I want it to be just one page only. can you please amend the database so that it doesn't repeat.

[#18]

I will try, but since I really can't figure out what you intend, it's kind of a guessing game.

[#19]

@Libin7963 

Here are two versions of a report which may be closer to what you need. 

[#20]

Thanks for the report but if you look at the report I created, the value I wanted was the received count for a specific period. Can you use the same below. Since it is just sort of summary info. from query it shouldn't be repeating on same page or to more than one page.

=Count(IIf(([Type] In ("A13","A07","A18",)) And ([Datevalid] Between #01/04/2020# And #31/03/2021#),[ID]))