Creating a table that checks matches two values to another table to replace the values

Hi Jsaidtecnimont ,

I think the simplest way to go about this would be to just Left Outer merge your New Query (NQ) onto your First Query (FQ) on FQ[Project] and FQ[Object Code] = NQ[Project] and NQ[Old Object Code].

You can do a two-field merge by using Ctrl+click on the fields in the merge dialog. Make sure to Ctrl+click the fields in the same order on each table:

Pete

Hi,

if i understood you want to get in the first table the new object code

you need to merge the first query this way

then expand this way 

and you get this

If this post is useful to help you to solve your issue consider giving the post a thumbs up 

 and accepting it as a solution !