I have an access query join as follows:
FROM GSACatalogReports_2013r1_to_2012r2_PriceChanges INNER JOIN tblPFile_temp ON
GSACatalogReports_2013r1_to_2012r2_PriceChanges.[Dealer/Reseller PN] = tblPFile_temp.PN_id
I know there's a way to make both records identical and I have it in another query but I don't have time to go through 100+ queries trying to find where I solved it before.
so can anyone remind me, please?
it's something simple like adding CLIN( before both joined fields but it's obviously not CLIN...