Changing Source of a Report

D

Dahlman

I have 8 reports that are all set-up the same, however they come from 8
different queries. I could use 1 query and just change my specifications but
it's more time consuming and more complicated for the peolple who will be
running the reports off them. What I would like to do is create a report from
my first query (I've already done this) but then just copy and paste that
report with a new name and then change my query source to the appropriate
query. Is this possible or no. Please let me know. Thanks in advance for the
help.

Travis Dahlman
 
J

Jackie L

I do not know your reasoning for th 8 queries. When you say "change my
specifications", do you mean the data in the query or the criteria? If it is
the criteria, then you should probably be using a form for the query
parameters.

Either way, to answer your question. Yes, you can copy your reports and
then change the record source. That's how its done.

Hope this helps.
 
J

John Vinson

I have 8 reports that are all set-up the same, however they come from 8
different queries. I could use 1 query and just change my specifications but
it's more time consuming and more complicated for the peolple who will be
running the reports off them. What I would like to do is create a report from
my first query (I've already done this) but then just copy and paste that
report with a new name and then change my query source to the appropriate
query. Is this possible or no. Please let me know. Thanks in advance for the
help.
Click to expand...
If your eight queries differ only in the criteria, then you should use
ONE *parameter* query. For example, rather than separate queries for
Paris, London, Hong Kong, Amsterdam etc., you could have a Form named
frmCrit with a combo box cboCities (with the relevant city names); use
a criterion of

=[Forms]![frmCrit]![cboCities]

and put a command button on frmCrit to open the report.

If the queries differ in some other manner, post back - there's surely
a better solution than changing the Report every time!

John W. Vinson[MVP]
 
M

Michael J. Strickland

For each report:

Select the report.

Click "Design" button.

Right click on the upper left corner of the design screen.

Select "Properties".

Change the "Record Source" to the query you want as the source of the
report.
(select it from the dropdown list).
 
Top