Tech Support Guy banner
Status
Not open for further replies.
1 - 2 of 2 Posts

·
Registered
Joined
·
52 Posts
Discussion Starter · #1 ·
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
 

·
Registered
Joined
·
2,556 Posts
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 .
 
1 - 2 of 2 Posts
Status
Not open for further replies.
Top