Combine data from one table to another based on unique ID and depth ranges

[JoBland]

I have 2 tables I would like to combine based on the unique ID and depth ranges. The image below is an example of what I need the query to do. The type3 and type4 values from table2 need to be populated into table1 using the depth ranges. If the depth range in table2 falls within the depth range in table1 then type3 and type4 columns in table1 are populated with the values from table2. In addition, I need the comments to concatenate. How can I do this with a query? Thanks for any guidance!

[June7]

Try:

UPDATE Table1 INNER JOIN Table2 ON Table1.ID = Table2.ID SET Table1.Type3=Table2.Type3, Table1.Type4=Table2.Type4, Table1.Comments = Table1.Comments & "," & Table2.Comments WHERE Table2.depthFrom>=Table1.depthFrom AND Table2.depthTo<=Table1.depthTo;

[JoBland]

This worked perfectly and saved me so much time! Thanks!