Microsoft Access Database Query
Closed - This job posting has been filled and work has been completed.
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.
Other open jobs by this client
- Fixed-Price – Aviation T-Shirt Design
- Hourly – Product Unique Content Creative Writer for Aviation Ecommerce Company