Hi
I have a database with 625 records, I have been given another database that contains some new information relating to about 500 of these records that I need to add in as new columns. Both databases contain the unique identifying code for each record that could be matched. Is there a way access can do this?
From what I can tell appending would add the information in as extra records on the bottom, I need them to become additional columns. Is this possible?
I am not very experienced with access and would appreciate clear, step by step instructions. I have got myself very confused trying to read help sites!
Thank you