How to change databases in report

J

Jim H

I am trying to create a report to format data that I import from Excel.
(Bear with me, I am not a developer and only somewhat Access savvy.) I
created the report and like the results. Now I want to use another set of
data and complete the same report for that data. Can this be done? I
thought I could could just rename the new Excel database the same name as the
old and the changes would take place but I am still getting the old data.
Any tips?
 
D

Duane Hookom

If you import from Excel, then I assume your data is stored in an Access
table. Your report has a record source of your table or tables (in a query).

Do you want to change the record source of your report?
Or, do you want to simply filter the same record source differently?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Access 2002 change report header text 0
Embed the same Excel multiple times 0
Need Help Creating a Word Template using Excel 1
unable to save report revisions 1
copy format and formulas of one report to a second report 2
Obtain report page count with out previewing the report. 2
Copy a report from one database to another 5
Change characters in report 4

Top