I'm working on a query that will allow me to lookup fields (about 15 in all) in 2 different tables and attempt to ascertain if they match. If they do then I don't need to do anything but if not then I'll need to show certain fields.
Attached is a breakdown of the fields I need to lookup and match and the fields I need to report back on.
Any advice/assistance is greatly appreciated. I'm not sure if I've provided enough info here so happy to give whatever is needed.