Access 2000 Question: Same report, different table

[Mark]

I am a new user to Access. Is there a way to use an
already existing report format for a different table? In
other words, I have a format I like for a report, I would
like to use that format on a table that has similar
fields. Is there a way to reference the report to a
different table? Your help would be appreciated.....

 

[Chris]

Open the report in design view, then click on Properties. On the Data tab,
change the recordsource.

You will probably have to do the same for all fields as well.

 

[John Vinson]

I am a new user to Access. Is there a way to use an
already existing report format for a different table? In
other words, I have a format I like for a report, I would
like to use that format on a table that has similar
fields. Is there a way to reference the report to a
different table? Your help would be appreciated.....

Change its Recordsource property to the other table, or to a query
using that table...

BUT!!!!

The need to do this STRONGLY suggests a problem with your table
design. If you have two tables that contain the same general type of
data - similar enough to use the same report - you're almost certainly
violating relational design principles by storing data in a tablename.
You'll almost surely be better off using ONE big table with an
additional field distinguishing the categories you're now using as
tablenames, and base your report on a Query selecting just the desired
subset of the data.