Access 2000 Question: Same report, different table

  • Thread starter Thread starter Mark
  • Start date Start date
M

Mark

I am a new user to Access. Is there a way to use an
already existing report format for a different table? In
other words, I have a format I like for a report, I would
like to use that format on a table that has similar
fields. Is there a way to reference the report to a
different table? Your help would be appreciated.....
 
Open the report in design view, then click on Properties. On the Data tab,
change the recordsource.

You will probably have to do the same for all fields as well.
 
I am a new user to Access. Is there a way to use an
already existing report format for a different table? In
other words, I have a format I like for a report, I would
like to use that format on a table that has similar
fields. Is there a way to reference the report to a
different table? Your help would be appreciated.....
Click to expand...

Change its Recordsource property to the other table, or to a query
using that table...

BUT!!!!

The need to do this STRONGLY suggests a problem with your table
design. If you have two tables that contain the same general type of
data - similar enough to use the same report - you're almost certainly
violating relational design principles by storing data in a tablename.
You'll almost surely be better off using ONE big table with an
additional field distinguishing the categories you're now using as
tablenames, and base your report on a Query selecting just the desired
subset of the data.
 
Back
Top