Moving Reports between databases

O

OldManEd

I have two database files with nearly identical structure but different
data. One has a report that I would like to use in the other one. I know I
will have to make some changes afterwards but I first need to know how to
move this report's structure, not data, from one to the other. Thanks for
help.
EdC
 
M

Mike Revis

Ed,

Working from the db that you want to bring the report to.
File / import
You are aware, it seems, that you will have to change a few things on the
imported report.

Mike
 
O

OldManEd

Thanks but have a clarification question. Will this import ONLY the report's
structure?

Ed
 
F

fredg

Thanks but have a clarification question. Will this import ONLY the report's
structure?

Ed
Click to expand...

Yes, because reports don't have any data, they just show the data from
the tables/queries that are the report's record source.

You can also simply select the report in the main database window.
Copy it. Open the second database, click on Reports, and Paste.
Now you'll have to make sure the record source is correct in the new
database.
 

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

Access Access Report Works on One Machine but not Another 3
TransferDatabase help...totally lost 5
Reports that sift records from different tables 0
Help needed #MsAccess 1
Possible Report Issue 1
how to convert database written in Turkish MS Access to English MSAccess 2
How do I merge data from 2 identical databases? 2
conditional formatting a report based on a query 2

Top