Unanswered: help needed with merging identical tables
I could some help please. I have two tables that each hold an id number (a 6 digit pin). The two table are created based up several queries and queries of queries and the result is these two table that have identical types of data that need to be joined into one result set with pin and name. I would like to use something to join to the two together (besides exporting them as text files, concatenating them together and then re importing since my data changes from week to week). Problem is, my result set should be under 300 and I am getting 9076 + results in my attempt to join the two tables (and I don't mean inner, out or left join just a merge of the two bits of data
These are the resulting tables that need to be merged:
Maybe I am 'just having a Monday' since I having being doing db development for about 4 years now (primarily for the web though so this whole Access forms and reports thing is new to me) but I can't figure out how to join the two with a form, or a report, or a query. Any advise?