copying a report

[Sanjo]

my database has 3 tables. I have created a report that accesses data from table 1. I then copied the report and want to change that copied reports' source of information to come from table 2. How do I change its source? It should be easy, but I am having a hard time.\\\


thanks

 

[Sanjo]

oopps. the tables are Access 2010 tables

 

[Geotch]

Go to properties of the report and change the Record Source. See attached picture.