Adding tables to already created Access reports

Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Swanny86uk

Thread Starter
Joined
Dec 1, 2006
Messages
52
Right this one is seriously picking at our tiny brains ...

We have created a report in Microsoft Access and realised halfway through that we needed to add a table to the report. So how do we add this table to the report without having to start again ? ?

Tell me its something grossly simple and that its only the effects of 10 hours at work stopping us finding it :mad:

Thanks guys

Marc
 
Joined
Jun 17, 2002
Messages
2,556
CreATE A join query using both tables, you need to drag a link to the related fields (KEY). If it automatically joins them make sure it is related data other wise delete the join. Add all the fields from the first table and some (or all) from the second

Eg if table 1 has an item code

and table 2 has transaction history by Item

then join the 2 fields, keep in mind that you may need to join more than one related field, study the data, if you see duplicated records then you need to refine the joins

Then go into the report design and change the control source to the query. The report should still display as it did with the table, but now you will have th additional fields.

You have to be careful because in my example above is a One to many scenario, so if you want One to one you may need to make a summary query first to restrict the data .
 
Status
This thread has been Locked and is not open to further replies. The original thread starter may use the Report button to request it be reopened but anyone else with a similar issue should start a New Thread. Watch our Welcome Guide to learn how to use this site.

Users Who Are Viewing This Thread (Users: 0, Guests: 1)

As Seen On
As Seen On...

Welcome to Tech Support Guy!

Are you looking for the solution to your computer problem? Join our site today to ask your question. This site is completely free -- paid for by advertisers and donations.

If you're not already familiar with forums, watch our Welcome Guide to get started.

Join over 807,865 other people just like you!

Latest posts

Staff online

Top