How to copy the format of a report to apply it to another table?

P

Purple

I have one report based on a table. I need to create identical reports for
other tables. Is there a way to simply copy the report format?
 
B

Bryan

Purp -

I usually Save the Report with a different name (in Design View, File ->
Save As), then change the Record Source to the new table.

Of course, you would have to change the Control Source for any text boxes
that do not have the same name in the new table as the original table.

Bryan..
 
J

John W. Vinson

I have one report based on a table. I need to create identical reports for
other tables. Is there a way to simply copy the report format?
Click to expand...

Just copy and paste the report to a new report and change the Recordsource
property... BUT!!!

Linq is absolutely correct. If you have multiple tables of identical
structure, differing only by table name, your database structure is *wrong*.
You should NEVER store data in tablenames.

Instead, put all the data in *one* table, with an additional field to
distinguish what are now separate table names, and base your report on a Query
selecting a subset of the data based on that field.
 
Top