I need to add to the query below an IIF statement which will make EstShipCost $0.00 if products.localdiscontinued
=true. By the way, InventoryProfile.EstShipCo
st is currently null if products.localdiscontinued
=true, and my code is breaking because I don't want any null values passed. There needs to be a number, and $0.00 will suffice. InventoryProfile.EstShipCo
st is a Currency field.
SELECT KWS.SKU, KWS.Price, BB_stock_status.shipping, InventoryProfile.EstShipCost, InventoryProfile.MAPPricingAmount, Products.LocalDiscontinued
FROM ((KWS INNER JOIN Products ON KWS.SKU = Products.SKU) INNER JOIN InventoryProfile ON KWS.SKU = InventoryProfile.LocalSKU) INNER JOIN BB_stock_status ON KWS.SKU = BB_stock_status.product_id;