Change data source of existing report

[Caldo]

I have an existing report and would like to maintain the current format but
use a different query as the source data. Is it possible to do this? I
realize that I will have to change the fields but I like the format and do
not want to have to create a new report if possible.

 

[Marshall Barton]

I have an existing report and would like to maintain the current format but
use a different query as the source data. Is it possible to do this? I
realize that I will have to change the fields but I like the format and do
not want to have to create a new report if possible.

Try selecting the report in the db window and using
Copy/Paste. Then open the copy in design view and change
its record source property.