This maybe a long way around but it will get you there. The first query gives
every property a ranking number and makes a table named mmais-2 from table
mmanis.

SELECT Q.CustId AS Customer, Q.Name AS Client, Q.PropType AS Property,
(SELECT COUNT(*) FROM mmanis Q1
     WHERE Q1.[CustId] = Q.[CustId]
       AND Q1.PropType < Q.PropType)+1 AS Rank INTO [mmanis-2]
FROM mmanis AS Q
ORDER BY Q.CustId, Q.PropType;

This second query pulls the data from mmanis-2 and creates a field for each
rank (property item).  Set the IN(xxx   function for the maximum number of
property items any may have (I set for 6 here).
mmanis-2_Crosstab --
TRANSFORM First([mmanis-2].Property) AS FirstOfProperty
SELECT [mmanis-2].Customer, First([mmanis-2].Client) AS Name
FROM [mmanis-2]
GROUP BY [mmanis-2].Customer
PIVOT [mmanis-2].Rank IN(1,2,3,4,5,6);

This query is built for the max of 6 property.  For more add to the query.
SELECT [mmanis-2_Crosstab].Customer, [mmanis-2_Crosstab].Name, [1] & IIf([2]
Is Null,Null,", " & [2]) & IIf([3] Is Null,Null,", " & [3]) & IIf([4] Is
Null,Null,", " & [4]) & IIf([5] Is Null,Null,", " & [5]) & IIf([6] Is
Null,Null,", " & [6]) AS Property
FROM [mmanis-2_Crosstab];