Hello. I have two Vendor tables... oops... that I need to make into one table. My problem lies in that we have added vendors to both tables. Some vendors are only in tblVendors and some are only in tblPurOrdVend and some are in both. I want just a list of all my vendors in one table. I was going to use an append query, but I don't know how to not add the vendor if there is a duplicate vendor name. Any ideas?