Hi
I have a query and with one of the fields I want to exclude 0 values but keep NULL. I have a WHERE clause to exclude 0 but it also removes NULL and that is not the behaviour I want.
Here is my query, the WHERE clause is in red.
Code:
SELECT
qryPlan.warehouse,
qryPlan.area,
qryPlan.bay,
Round([SumOfbin_width_mm]/[bay_width_mm]*100,1) AS [Capacity %],
qrySumOfBinSize.SumOfbin_width_mm,
qryPlan.bay_width_mm,
qryPlan.bay_depth_mm,
qryPlan.bay_height_mm,
qryPlan.bin,
qryPlan.bin_width_mm,
qryPlan.priority,
qryPlan.bin_type,
qryPlan.product,
qryPlan.dimension,
qryPlan.long_description,
qryPlan.catalogue_number,
qryPlan.bin_number,
qryPlan.physical_qty,
qryPlan.PTZ_replen_min,
qryPlan.PTZ_replen_max,
qryPlan.PTZ_fullpallqty,
qryPlan.comment
FROM
qryPlan LEFT JOIN qrySumOfBinSize ON qryPlan.bay = qrySumOfBinSize.bay
WHERE
(((qryPlan.bin_width_mm)<>0))
ORDER BY
qryPlan.warehouse, qryPlan.area, qryPlan.bay, qryPlan.bin, qryPlan.priority, qryPlan.product;
Is there a way i can achieve this?