title: UPDATE QUERY IN ACCESS 2010
body: <p>Ok, so I have a table that is populated from a generic crosswalk. But I have a second crosswalk that I need the values to replace those in the original table. Here is an example.</p>
  
  <p>When i run the generic crosswalk the following results would return. (There are more columns, but they don't matter)</p>
  
  <p>PAT/              FCP/        Service Line/      Business Manager</p>
  
  <p>RT 646A40021/     123/         Logistics/           John Smith</p>
  
  <p>However, our Logistics department has determined that that PAT belongs to Medicine, so I created another crosswalk that</p>
  
  <p>PAT/                Service Line/      Business Manager</p>
  
  <p>RT 646A40021/       Medicine/          Joan Jackson</p>
  
  <p>Most of the PAT's that belong to FCP 123 will stay with Logistics, but That one in the second table needs to reflect Medicine rather that Logistics.</p>
  
  <p>I need a query or Code that will look for the look for the PAT to match in both lists and then change the Service Line and Business Managers values in the first list.</p>
  
  <p>The Tables names are Open Orders by Service Line Payables and FMS-Logistics Crosswalk respectively.</p>
  
  <p>I can email the tables for a more specific example. I cannot write SQL code so for me that is not an option. I've tried several avenues to complete this task, but I have failed miserably. Please help</p>