• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 470
  • Last Modified:

Use existing Report template with data in a different table

I have a report set up just the way I want it in terms of headers, footers, margins, fonts etc.  It's linked to Tbl1 at the moment.  I now want to use the same report struture for Tbl2.  I've copied and pasted the Report but how would I bind it to the fields in Tbl2?  Thank you.
1 Solution
In a MS Access report you would change the RecordSource for the report (Report Properties --> Data Tab --> Record Source). http://office.microsoft.com/en-us/access-help/change-the-record-source-or-connection-information-HP005187656.aspx

In MS Excel, you'll need to change the cell references for any charts or graphs to point at the new data. http://office.microsoft.com/en-us/excel-help/add-data-to-a-chart-HP005198472.aspx
GIStewartAuthor Commented:
Thank you; I used the info for an Access report, and it worked just the way I expected.

Featured Post

Industry Leaders: We Want Your Opinion!

We value your feedback.

Take our survey and automatically be enter to win anyone of the following:
Yeti Cooler, Amazon eGift Card, and Movie eGift Card!

Tackle projects and never again get stuck behind a technical roadblock.
Join Now