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.
