Merge tables by columns, not rows

[hunoob]

Hi there Everyone. First of all I am very new to Access, so please try to explain detailed if you can. My problem is that I need to merge/join two databases/tables, but horizontaly (not verticaly). This means that the tables should be united by adding the data to columns and not rows. I hope you understand my problem! Thank you for your help in advance and have a nice weekend!

 

[Rabbie]

Not sure I fully understand your explanation of what you want but woulld a normal query do what you want
so if you want a record that looks like

Table1.Field1, Table1.Field2,Table2.Field1, Table2.Field2

Then you should be able to do this with a Select query.

Please clarify what you actually want.

 

[gemma-the-husky]

if you have two tables you wish to combine in this way, then you need a UNION query

but the way you are phrasing the question inclines me to think that the problem is more likely to be that your data is not properly normalised.

so can you explain what you are trying to do in more detail

 

[hunoob]

Hi Gemma, sorry for my poor explanation.
So here is my problem.
I have two tables with the following columns:
Table1.Name, Table1.Address and Table2.Phone_number, Table2.ID_number
From these two tables I would like to create a joined table which would look like this:
Table3.Name, Table3.Address, Table3.Phone_number, Table3.ID_number
I hope this way is more understandable! Thank you!

 

[Rabbie]

Hi Gemma, sorry for my poor explanation.
So here is my problem.
I have two tables with the following columns:
Table1.Name, Table1.Address and Table2.Phone_number, Table2.ID_number
From these two tables I would like to create a joined table which would look like this:
Table3.Name, Table3.Address, Table3.Phone_number, Table3.ID_number
I hope this way is more understandable! Thank you!

Try looking at Post 2 where I explained what to do.

However we do need to know how Table1 and Table2 are connected. How do you know which record in Table1 is connected to which record in Table2.