bring 2 tables next to each other without id

[sanzoo]

Hello everyone,

Here is the tricky one I`m trying to put 2 identical tables in terms of structure and layout with some identical values next to each other however I dont have unique identifier. I was thinking to import them and let access to create Id field and match them together but i wasnt successful because for some reason access changed the order of some rows. Good news is that when I import these text files into excel Im able to put them next to each other in order. Any other idea how this could be achieved in Access?

Thanks and regards,
sanzoo

 

[plog]

You would link them by all the values that should be the same between the two. Suppose you had 2 tables with employee data:

Table1
FirstName, LastName, Department, Salary
John, Smith, Accounting, 42000
Sally, Jones, HR, 19000
David, Bishop, Sales, 48000

Table2
FirstName, LastName, Extension, ParkingSpot
John, Smith, 4236, 17
Sally, Jones, 5515, 19
David, Bishop, 6711, 48

To combine those 2 tables you would link on the FirstName and LastName fields of both.

 

[sanzoo]

but the thing is that I have several duplicates within the fields that are the same ...so when I take your example I have John Smith lets say twice in my table and David Bishop is present 3 times in ther. When I do it as you suggest it will multiply the rows and create another duplicates, right ?

 

[plog]

Yes it will.

Suppose you had to do this manually--you have 2 pieces of paper in front of you each representing a table. How would you know which John Smith on one sheet of paper went to a specific John Smith on the other sheet? Is there a third field, maybe a fourth?

If you can't do it manually, then there's no getting around that issue.

 

[sanzoo]

Yes there are other fields but these cant be used because they represent numeric info wchich varies in both tables...I could do it if access would keep the order while importing the data but for some reason it doesnt...however i can do it by bringing the text files into excel.