changing a report's datasource?

[phlash0r]

say I have a report referring a table, and want to copy that report and change it's data source to a different table (with the same variables and what not, just different data) instead of having to redo the report for each table in the database - possible, and if so, how?

 

[goaksmith]

Double click on the black square at the top of left corner of the report design. Go to the Data tab and change the record source to your new table.