Re-use existing database

  • Thread starter Thread starter confused
  • Start date Start date
C

confused

I want to use the same database, but need to create a new
report. Do I have to redesign it? How do I get the old
information out of the report to create a new report?
 
I want to use the same database, but need to create a new
report. Do I have to redesign it? How do I get the old
information out of the report to create a new report?
Click to expand...

You are confused, Confused... <g>

The data is not stored in your Report.

The way Access works is that data is:

- stored in Tables
- Assembled, combined, and sorted in Queries
- Entered and edited, and displayed on screens, in Forms
- Printed using Reports

A Report is just a special type of "program" which takes data from one
or more Tables and formats it into printable form. A Database is a
container for multiple tables, forms, reports and other objects; it is
perfectly routine to have many different Reports in a database.
 
I want to use the same database, but need to create a new
report. Do I have to redesign it? How do I get the old
information out of the report to create a new report?
Click to expand...

What is the problem in simply creating a new report?

If you wish to re-use an existing report and all that has changed is
the Report's record source, but the Field Names remain the same, then:
Open the Report in Design View. Display the report's property sheet.
Click on the Data tab. Enter the new record source.

If the field names are also different, then, after you do the above,
change the field names in the existing controls as needed. Click on
the control. Display it's property sheet. Click on the Data tab.
Change the Control Source to the new Field.
 
Back
Top