How to Create Linked Reports MS Access
Linked reports in Microsoft Access allow you to reuse and connect existing reports with different filters, sorting, or grouping criteria. Here’s how to do it:
- Right-click on the report in the 'Navigation Pane' and select 'Copy' then 'Paste'.
- Give the copied report a new name and click 'OK'.
- Right-click on the duplicated report and choose 'Design View'.
- In the ‘Design View’, go to the 'Property Sheet' for the report.
- Locate the 'Filter' property and enter a filter condition.
- On the 'Report Design' tab, click 'Group & Sort'.
- Add grouping levels or sorting orders as needed and click 'OK'.
- Click 'Save' and close the linked report.
This website uses cookies to ensure you get the best experience on our website. Learn More
Got it