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?