caledoniat
New Member
- Joined
- Feb 2, 2015
- Messages
- 1
In a database created in Access 2007, I have a Report that is filtered from a user input Form. The Master Report is grouped by the field "sAgent" and has a SubReport using the PolicyID field as the "Link Master/Child Fields" criteria.
Here's the problem:
When I put the SubReport in the sAgent Header of the Master Report, the results show only records for the first PolicyID from the master.
When I put the SubReport in the sAgent Footer of the Master Report, the results show only records for the last PolicyID from the master.
When I put the SubReport in the sAgent Details Section of the Master Report, the results are accurate, but they appear after each PolicyID, instead of a summary of all PolicyIDs (ideally in the report footer).
Any help is greatly appreciated!
Here's the problem:
When I put the SubReport in the sAgent Header of the Master Report, the results show only records for the first PolicyID from the master.
When I put the SubReport in the sAgent Footer of the Master Report, the results show only records for the last PolicyID from the master.
When I put the SubReport in the sAgent Details Section of the Master Report, the results are accurate, but they appear after each PolicyID, instead of a summary of all PolicyIDs (ideally in the report footer).
Any help is greatly appreciated!