Access Reports

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Is there a way if I already have a report made and I want another to look
exactly like it that I can use that report and base it on a different query
and save it? I know there is a way you can save the format in autoformat,
but that only saves fonts and colors. I want the column and row arrangements
to be the same too.
 
To duplicate a report and change its source:

1. Click the Reports tab of the Database window, and select the report.

2. Copy (Ctrl+C) and Paste (Ctrl+V), supplying a new name.

3. Open the new copy in design view. Open the Properties box (View menu).
Set the RecordSource property (Data tab) to the name of the query.
 
As Allen has pointed out, this can be done. I question the basic idea of
having multiple similar reports. You can usually have a single report where
you either change the Record Source property or the query that is the record
source.
 
Open the database window. Right click on the report and select Copy in the
dialog that appears. Right click anywhere in the blank area of the list of
reports and click on Paste in the dialog that appears. Another dialog will
appear asking you for the name of the copy. After you have entered the name
and closed the dialog, you will have two reports the same except with
different names. Go into the one created from the copy and open properties.
Go to the Data tab and change the recordsource to whatever you want. You can
also change any of the other properties of that report. The second report
now has the same layout as the first report but reports different data.
 
Back
Top