there is a crosstab query wizard in access, but it limits how many columns you can select.
Use this this wizard to create a simple crosstab, and the using designer edit the query to add extra columns as required.
Or you can code in SQL in access.
TRANSFORM First(dbo_vSid.[No Of Products]) AS [FirstOfNo Of Products]
SELECT dbo_vSid.Customer, First(dbo_vSid.[No Of Products]) AS [Total Of No Of Products]
GROUP BY dbo_vSid.Customer
The table this uses has 3 fields, YP, Customer, [No of Products]