I'm a little bit confused here. It will help to have the structure of your tables.

>>Try:
>>

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

HTH
>
>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?