Microsoft Access Database Query

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

Fixed Price

Budget: $50
Delivery by May 6, 2013

Start Date

May 3, 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.95) 89 reviews

United States
Lakeland 04:19 AM

137 Jobs Posted
79% Hire Rate, 1 Open Job

Over $50,000 Total Spent
124 Hires, 7 Active

$12.34/hr Avg Hourly Rate Paid
3,389 Hours

Member Since Aug 8, 2010