Hi I am a newbie to access and would like to know how to write a query to run a simple vlookup functions between these two:
Tabel1 : has 200,000 rows of data. Has the fields to be looked up- "Serial_Number" and "Ship_Date"
Table2: has the field :"Serial_No"
I want table3 to Lookup Serial_No (tabel2) in the Serial_Number in table1 and return the corresponding row value of Ship_Date