Microsoft Access Database Query

Closed - This job posting has been filled and work has been completed.
IT & Networking Database Administration Posted 2 years ago

Fixed Price

Delivery by May 6, 2013




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.

About the Client

(4.94) 77 reviews

United States
Lakeland 11:20 AM

111 Jobs Posted
78% Hire Rate, 1 Open Job

Over $50,000 Total Spent
101 Hires, 5 Active

$11.89/hr Avg Hourly Rate Paid
3,236 Hours

Member Since Aug 8, 2010