The attachment is a very basic crosstab example. The key thing in designing a crosstab type report is making it so that when new records are added to the table, you don't have to manually edit the report and add in a new column to show the new column of information. This can easily be done by making the subreport based on the crosstab query (not a subreport) as the report example illustrates. You'll also notice that you can adjust the column widths in the crosstab query which also reflect in the report.

Test out the example by adding/deleting records to the table and notice that you don't have to do anything to the report design.