create spreadsheet like report with counts

[viveleroi]

I have a table with hundreds of records that have two fields I want to count: a rating and a code field. I want to see counts of each code for each rating in a spreadsheet-like chart:

For example:

R: A B C
C:
1) 0 4 1
2) 1 3 6
3) 0 1 10

There are four ratings and thirty codes, and I dont want to have 120 textboxes with different queries - is there a way I do this that is a bit easier?

 

[Sergeant]

Try using a crosstab query.