Using multiple tables when creating report

  • Thread starter Nathan Vanderslice
  • Start date
N

Nathan Vanderslice

Can I use multiple tables from the same DB when creating a report, and if
so, how do I bring up the second table's list of fields? Note that I have
two tables with duplicated fields and would like to edit one table to
eliminate these fields, and link the ID fields before I start entering data
so that I can save a lot of extra typing. If I link two tables, will they
both automatically come up when one is brought up to design the report?
 
R

Richard

Yes you can use multiple tables to create a report. You
link them so that you can see the feilds from both table.
You may want to link them by the common field so you can
reduce the amount you have to input.
 

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

tables not linking properly 5
Using tables created in 2003 IN 2007 2
Can't create a report from my query in Access 1
create one table using multiple linked tables 6
Reports with multiple tables 5
Access Sorting and grouping using multiple tables 0
Generate a Report from Multiple Tables 1
Setting up tables properly 1

Top