This interactive demo was created free with Storylane in 2 minutes. Create your own demo
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'.
