Merging two tables into a new blank (1 Viewer)

[yadagiri8]

Hi friends,

I am having 3 tables in access with 10 colomns in each but 3 colomns are unique among 3 and the content not duplicating among 3

now can i pull these 3 colomns data into a new table like below

Please do needfull

 

[GinaWhipp]

Griad still not showing probably because this is your first post. So...

Welcome to the forum!

To put the columns into one you will either need an APPEND query, if a new table or an UPDATE query if an existing table.

UPDATE query

UPDATE tblYourTable SET tblYourTable.NewField = [Field1] & [Field2] & [Field3];

APPEND query

INSERT INTO Table2 ( tblYourNewTable)
SELECT [Field1] & [Field2] & [Field3] AS NewField
FROM tblYourTable;