Forum Discussion
Access report repeating to multiple pages
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.
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.
- It's good to hear you are on the right track. Continued success with your application.
Thanks, I just learned that it is avoiding the duplication by inserting the fields and labels in the Report Header part of the access report. It has now stopped repetition and all works fine. Thank you so much for your help all the way.
see attached database.
I used two subreports for convenience, one for applications received by year. One for applications decided by year.
- Not that hard to explain 😉.
A summary with two things in it:
Count of applications received in a given period.
Count of applications decided in that same given period. - Data is a list of applications
A. I want to get a summary that shows applications received for a period
B. Count of applications decided for a particular period. - I have not been able to reconcile your verbal description with the query and report.
I used your calculation. (Look in the design view). I added a group footer to summarize the totals, which is what I interpret "summary info. from query " to mean.
If you can, please explain, in a business narrative, what the data represents, WHY you need the report, what the "summary" represents and what elements are to be summarized, i.e. monthly by item, monthly total. Or what? 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]))Here are two versions of a report which may be closer to what you need.
- I will try, but since I really can't figure out what you intend, it's kind of a guessing game.