If I have generated a report with a given table or querry and I want to keep
the format, but change the source (table or querry), how do I do that?
Open the report in design view. View its Properties; on the Data tab the first
row is the Recordsource property.
This will be either the name of your table or query, or a SQL string (a local
query, basically).
Replace it with your other query name.
If you need to do this routinely, you should ask why you need different
queries for (apparently) the same kind of data - might a single Parameter
query letting you dynamically change the criteria for the query be an
alternative?
John W. Vinson [MVP]