Hi Richard, first thanks for your courses. I went from knowing nothing 5 years ago to being the go-to person in our company because I discovered your courses. I am stumped however on using NZ with a crosstab query to force a "0" instead of null. If it is in a course let me know which one to purchase.
Here is the query it excludes any part that has a quantity of "0"

TRANSFORM Nz(Sum(InventoryT.Qty))+0 AS SumOfQty
SELECT ComponentT.Part
FROM InventoryT LEFT JOIN ComponentT ON InventoryT.ComponentID = ComponentT.ComponentID
WHERE (((InventoryT.DOA)=True))
GROUP BY ComponentT.Part, ComponentT.ComponentID
ORDER BY ComponentT.ComponentID
PIVOT InventoryT.Qty;