I have a database with around 3,000,000 records organized by account number, and another database with 100,000 or so organized by the same account number. I import both these databases into Access, and link up the account numbers… I want to pull data from both databases in order to create a new table.
The problem is, there are some files that are in the table of 100,000 that are not in the table of 3,000,000 and when I create the new table, it simply omits those items. Is there a setting somewhere that will make it list every file from the list of 100,000, and if the data is not present in the list of 3,000,000 it will say “NA” or “Null” or something? I appreciate any advice anyone can provide! Thanks!