Copying Queries and Reports

[Guest]

Hello. I have 2 tables in my database. They are exactly the same structure
and have the same fields just different data. We will call them table 1 and
table 2. Table 1 feeds a bunch of queries. These queries produce about 20
reports I need. The second table (table 2) has the exact same structure and
fields as table 1 (just different data) . Due to some proprietary issues I
need to keep the data in two separate tables even though the structure is
exactly the same. Here is what I would like to do. I need to replicate the
same queries and reports for this second table that exists for the first
table. Is there anyway I can copy the existing queries and reports and
somehow rename them so that the new queries reference table 2 and the reports
reference these new queries that reference table 2? I would really rather
not recreate each query and report since it is the same structure and uses
the same fields it is just referencing a different table. Any help????
Thanks in advance!

 

[Guest]

Should be quite easy. In the main database window right click the report or
query or report select copy then right click in the open space , click paste
then give it the name you want. Then for the reports all you have to change
is the record source which is under the data tab of the reports properties.
(I assume this would change from table 1 to table 2). As for the queries
assuming they are standard queries, the quickest way would be just to open it
up in design mode and run along the table selection for each field and change
it from table 1 to 2.

Hope this helps

enrico