Copy Query & Report

Some time we need to create another report but slightly diferrent with the prevoius report. To make it eassy and save time, we can just copy existing Query & Report and make an ammendement.

To copy Query, just copy the Query & paste and rename with diferrent name

To copy Report, just copy the Report & paste and rename with diferrent name

Open report in Design View

Right click & click report properties as below

report properties

After that click propertiy sheet as below and choose Recod Source