That doesn't seem to work either. After dropping and adding lines to the code, it seems that the comparison line is where it hiccups.
Here is an example where I get the columns to display side by side. Still, the HAVING is where I don't yet have it. If I omit the HAVING, the query runs fine.
COUNT(PA.OrderID) AS TotalParcels,
COUNT(*) AS 'TotalParcels'
tblParcelAssigned as PA
tblOrder AS O
ON O.OrderID = PA.OrderID
PA.Type = 2
-- o.Pieces <> Count(*)