 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
MS Access Forum / New Users / March 2007Combining tables in Access
I have two tables in Access that i want to combine, but the issue is they have unique columns with some shared columns that i need to combine so that in the final product the shared columns combined and the unique comlumns alined with them or "reconciled" Can this be done? Aaron If you were describing this task to someone doing this manually, how would you tell them that the records in the two tables were related. That is, how do you know that, say, record 3 in Table1 is the same record as record 17 in Table2?  SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > I have two tables in Access that i want to combine, but the issue is they > have unique columns with some shared columns that i need to combine so that > in the final product the shared columns combined and the unique comlumns > alined with them or "reconciled" > Can this be done? Well Jeff, this is table databasing accidents, table 1 has a lot more fields (columns?) then table 2. But all these accidents that we are logging we assign a unique Id# number to. Seeing that we only need one field (column) from table 2 I was hoping to match the records (lines) with the ID# and adding that one column to from 2 to 1. I guess to more specifically answer you question, we match them off the unique ID# number, date, and name of person that had the accident. Remember though the ID# is the ONLY unique Identifier. Does that answer your question Jeff? > Aaron > [quoted text clipped - 9 lines] > > alined with them or "reconciled" > > Can this be done? Aaron If you create a new query, add both tables, and join them on the ID fields, you should be able to add fields from both tables. If you need to update a (?new) field in Table1 from the corresponding value in Table2, you could do this by changing your query to an update query. SignatureRegards Jeff Boyce Microsoft Office/Access MVP http://mvp.support.microsoft.com/ Microsoft IT Academy Program Mentor http://microsoftitacademy.com/ Microsoft Registered Partner https://partner.microsoft.com/ > Well Jeff, this is table databasing accidents, table 1 has a lot more fields > (columns?) then table 2. But all these accidents that we are logging we [quoted text clipped - 19 lines] > > > alined with them or "reconciled" > > > Can this be done? |
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.