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

$50.00

Budget

Details

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) 71 reviews

United States
Lakeland 02:28 PM

104 Jobs Posted
76% Hire Rate, 2 Open Jobs

Over $50,000 Total Spent
94 Hires, 4 Active

$11.57/hr Avg Hourly Rate Paid
3,073 Hours

Member Since Aug 8, 2010