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

  • Thread starter Thread starter Purple
  • Start date Start date
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?
 
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..
 
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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Date format in a report 2
Access Access Report Works on One Machine but not Another 3
How to copy aQuery to a new Table? 3
Report Query Works 2nd Time, But Not 1st 14
How to export reports to html format automatically 0
Creating a report 4
Access Sorting and grouping using multiple tables 0
Can't create a report from my query in Access 1

Back
Top