microsoft access training course - Access reports

Hi Richanjit, Thanks for the post, this is a great question, but it depends very much on one thing, does the second query have the same fields as the first?
If this is not the case you will have orphan fields in your new report. However if they are compatible then your course of action is to change the Record Source option.
To do this; in the Database window, copy and paste the old report giving it a new name. Open your new (duplicate) report and change to Design view, open the Report Properties sheet, (All tab) and in the Record Source option, click the drop down arrow and choose your new source.
Hope that helps best regards Pete