Hi I am new here. This is probably an easy question but I have not been using access long and would appreciate some help. What I want to do is query two tables. The first table has fields INST_NBR and PRICE_LIST that I need to find a match on in another table with the exact same field names. Whe a match is found, I need to populate a new table that is already defined with fields from both of the tables I used in my query. So lets say I have table 1 and table 2. I want to use the fields INST_NBR and PRICE_LIST from table 1 to find the match in table 2 using the same field names. When I find a match on the two fields populate table 3 with fields from table 1 and table 2.
I hope that this is not confusing. Unfortunatly I cannot post a sample because they are linked table from our SQL server. Any help would be appreciated. Thanks in andvance.
I hope that this is not confusing. Unfortunatly I cannot post a sample because they are linked table from our SQL server. Any help would be appreciated. Thanks in andvance.
