Changing the table sourced by a report

  • Thread starter Thread starter Graham Lewis
  • Start date Start date
G

Graham Lewis

I have got a report set up the way I want, to display the data in an Access
table and now I want to use that same report format to display the data in
series of other tables, all structured in the same way.

I've copied the original report, changed its name and headings, but I can't
see how to change the table that its bound to. The Help files (Access 2000)
don't help, so far as I can see, and neither does the Microsoft online
knowledge base.

Any suggestions gratefully received

Graham
 
Graham said:
I have got a report set up the way I want, to display the data in an
Access table and now I want to use that same report format to display
the data in series of other tables, all structured in the same way.

I've copied the original report, changed its name and headings, but I
can't see how to change the table that its bound to. The Help files
(Access 2000) don't help, so far as I can see, and neither does the
Microsoft online knowledge base.

Any suggestions gratefully received

Graham
Click to expand...

RecordSource property on the Data tab of the property sheet.

By the way...multiple tables with the same structure *screams* improper design.
You should have one table with an additional field that distinguishes the sets
of records that you now have in separate tables. Then you would need exactly
one report for all of the data.
 
In order to Clarify Rick's answer only, open the report in design mode, there
is a little square box with a black centre where the top ruler joins the
lefthand ruler (Top left corner). Right click on this and select properties
the same as if it was a form. As rick then says RecordSource property on the
Data tab of the property sheet.
 
Back
Top