redirect report to read new table

[beancounter]

I have two tables (Table1 & Table2)

Both tables are identical but the data is different (i.e., the fields are exactally the same)

I want to use a report that pulls data from Table1 to pull the data from Table2 instead.

How do I do that without recreating the report????????

Thanks in advance

 

[bmacr]

Open your report in design view, open the properties window from the VIEW menu, on the DATA tab change the RecordSource property from Table1 to Table2.