Forum Discussion
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...
Here are two versions of a report which may be closer to what you need.
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]))
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?