TRANSFORM Count(Table1.[ID]) AS CountOfID
SELECT Table1.[Field1]
FROM Table1
GROUP BY Table1.[Field1]
PIVOT Table1.[Field2];