>Try:
>

SELECT Inv.Location, Count(OnHand.PK);
>   FROM Inv;
>   LEFT OUTER JOIN OnHand ON Inv.PK = OnHand.FK;
>   GROUP BY Inv.Location

HTH
>

Actually, that did help, I didn't realize how grouping worked before...I used SUM() instead of COUNT() to get the total on hand...Thanks Sylvain!!

But now, if I search on a part in location 01 and it's there's no stock in location 01, in which case there wouldn't be an entry in the onhand table, how do I get it to select that part number and instead say that onhand=0?