changing the layout of a report

[Guest]

I have a report now that I made with the wizard that looks something like this:

Month [Month]
Channel [Channel]
Sales: [Count]
Technical: [Count]
etc.

the records are grouped by date (on month), then by channel. The sales and
technical of the two types of records that could belong to a channel in a
given month.

I want it to look something like this:

Channel July August September etc
[Channel]
Tech # # #
Sales # # #

I just don't have the report making experience to alter the look of a report
much beyond what the wizard spits out. Any help would be appreciated.

 

[Duane Hookom]

Take a look at this article on reports with dynamic monthly headings
http://www.access.hookom.net/DynamicMthlyCrosstabRpt.htm