Hi I have Two tables with identical field names with information reagarding a physical catalogue from one site and a catalogue from another site I would like to join them utilizing there manufactorer code. And ignore all the duplicates.

Any assistance greatly appreciated.

Use an append query to append one to the other. If there are duplicates it will show an error but you can just continue and it will append all non duplicates.

Thanks Bob, I ended up creating a third master table and then two append queries which gives me exactly what I need.

Thanks for the point in the right direction :cool: