Rows into Columns

[fcp]

Crosstab query might be worth trying then.

[boblarson]

Crosstab query might be worth trying then.

Nope, a crosstab will give the values at the very top and the COUNT of each. It will not present it the way the original poster (OP) had requested. A clear understanding of what a crosstab does, what a Union Query does, and what they don't do is important.