NearImpossible
Registered User.
- Local time
- Today, 13:26
- Joined
- Jul 12, 2019
- Messages
- 225
I have 2 select queries that run to populate an access report whenever the report is opened.
The first query gathers facility information and the second gathers all sub records for that facility based on specified criteria.
The issue is whenever I open the report, its only displaying 3 of the 5 sub-records.
If I manually run the queries, or manually open the sub-report, all 5 sub records are displayed in the table, but no matter what I do, I can only get 3 to display when I just open the main report.
The sub report is not linked to the main report in anyway, that I am aware of anyway.
any thoughts ???
After some more investigation, if I look at the report in Report View, everything displays correctly, however if I look at it in Print View, only 3 records are displayed.
As I am exporting this to a PDF file on creation, it is only doing the 3 records
The first query gathers facility information and the second gathers all sub records for that facility based on specified criteria.
The issue is whenever I open the report, its only displaying 3 of the 5 sub-records.
If I manually run the queries, or manually open the sub-report, all 5 sub records are displayed in the table, but no matter what I do, I can only get 3 to display when I just open the main report.
The sub report is not linked to the main report in anyway, that I am aware of anyway.
any thoughts ???
After some more investigation, if I look at the report in Report View, everything displays correctly, however if I look at it in Print View, only 3 records are displayed.
As I am exporting this to a PDF file on creation, it is only doing the 3 records
Last edited: