Help re-creating these Excel Pivot Tables as queries in Access

[accessmatt]

Hello,

Can anyone help me re-create these Pivot Table examples as queries of the same data in Access? Results would be as Count (exactly as in the example).

[June7]

An aggregate query gets the first output.
SELECT Table1.Color, Count(Table1.ID) AS CountOfID FROM Table1 GROUP BY Table1.Color;

http://allenbrowne.com/ser-67.html

Have you tried using the CROSSTAB query wizard? It does require 3 fields. Review http://www.datapigtechnologies.com/f.../crosstab.html

The second output will likely involve 2 or 3 queries. However, I can't reconcile the output with the raw data example.