En cours

Access Project May 08 2012 21:29:25

Table A, B, C contain Price and Inventory Information. Table Products contain the products that I need to retrieve Price and Inventory from Table A, B, C if they exist in those 3 tables. For example “APrice” means Price from Table A, “AInventory” means “Inventory from Table A.”

To match a product, you can use 2 criteria:

1) When UPC on Table Products is not blank and not “NA” and not “N/A”, search the same UPC in Table A, B and C and retrieve the corresponding Price and Inventory information and save it in the “APrice,” “AInventory,” “BPrice,” “BInventory,” “CPrice,” and “CInventory.”

Maybe something like: If UPC > 0 And Not Null And Not "NA" And Not "N/A", then ….

2) When UPC is blank or “NA” or “N/A,” or “000000000000”, search Brand AND Mfg. When both Brand AND Mfg are exact match, retrieve the corresponding Price and Inventory information and save it in the “APrice,” “AInventory,” “BPrice,” “BInventory,” “CPrice,” and “CInventory.”

If cannot find match in Table A/B/C, then return value 0 to corresponding “APrice,” “AInventory,” “BPrice,” “BInventory,” “CPrice,” and “CInventory.”

Then, find out the minimum price among APrice, BPrice and CPrice and save it in MinPrice. MinInventory is the corresponding inventory for that minimum price. However, if the inventory is zero, then the lowest price shouldn’t be counted as minimum price. The second lowest price with available inventory (as long as inventory>1) would be the minimum price.

Field Inventory would be a sum of all available inventory from AInventory, BInventory and CInventory.

Compétences : Microsoft Access

Voir plus : may 2, inventory value, product inventory access, product upc find, product upc, need upc product, need upc, upc information, upc search product, access inventory value, inventory value access, need null, upc search, access search criteria, search criteria access, find price upc, search access, access inventory table, project inventory access, save table access, brand project, retrieve product information, access inventory tables, access inventory example, access save

Concernant l'employeur :
( 1 commentaire ) Bayside, United States

N° du projet : #1618637

Décerné à :


Hired by the Employer

200 $ USD en 1 jour
(60 Commentaires)