Trying to create report with months as column headers

[Patricia R.]

Hi,

I'm trying to create a report which will sort the records
by month according to a date field, with the months as
columns across the top, similar to a crosstab query. The
problem is, I don't want to report a count or function in
each "cell," I want to report the information entered in
that record for each month.

To try to clarify, this is how my table is structured
(with sample data):

Project # Proj. Name MeetingDate Notes
00001 Proj.A Jan. 1/03 NoteA
00002 Proj.B Jan 1./03 NoteB
00001 Proj.A Feb. 1/03 NoteC

I want the report to return:

Project # Proj. Name January February
00001 Proj.A NoteA NoteC
00002 Proj.B NoteB

However, Access doesn't seem to like grouping horizontally
across the page, only vertically, so what I get is more
like:

Project # Proj. Name MeetingDate Notes
00001 Proj.A Jan. 1/03 NoteA
00001 Proj.B Feb. 1/03 NoteC

00002 Proj.C Jan. 1/03 NoteB

In that way, every entry gets its own separate line, which
will make for a long report, and makes it harder to
compare notes from month to month. We were doing this in
Excel, but wanted to include our notes with the other
project information we have already stored in a database
and produce these reports as needed. Is it possible to
create a report that will give us what we want?

To make matters more complicated, I have some knowledge of
creating tables and simple queries and reports, but I only
know a few programming commands, so I'm hoping it's not
going to involve a lot of programming.

Any help would be very much appreciated!

Patricia