Hi, I'm pretty new to Access. I have an update query that is working, it compares to fields and if both of them match, it updates a third field in table 1 from a third field in table 2. The problem is that sometimes the data matches more than one time and I need both results to be inserted into the third field, possible separated by a comma? Below is the SQL view of my update query that I made in design view. Your assistance is most appreciated.
SQL:
UPDATE table1 INNER JOIN table2 ON (table1.[t1_number] = table2.[t2_number]) AND (table1.[t2_rev] = table2.[t2_rev]) SET table1.t2_vid = [table2].[t2_vid];