I have a Microsoft Access Database with 2 Tables (Products & Supplier). "Products" is a list of all of our products, associated data and our SKU. "Supplier" is a list of our SKU's and also the Supplier's SKU. I need a query written to merge them with the following changes:
In Products, if AttributeSKU is populated, AttributeAltID should be populated with the SupplierSKU from the Supplier database.
In Products, If AttributeSKU is NOT populated & AltID is NOT ALREADY populated, AltID should be populated with SupplierSKU
That's all I need. I can't see this taking more than a few minutes to do, but I'm not the greatest with databases. Please quote cost to do this simple job. The Access DB is roughly 40MB.