How do I show monthly data?

[wimsteve]

I work for a nonprofit org. Our donors give funds to specific causes usually
on a monthly basis. I need to generate a report that lists the donations by
cause over a three year period, catagorized by month. Each cause can have
several donors and I need to seee the donors grouped separately. I can get
it to generate a report with the information I need but it lists the
information in one column. I need the information to be listed in 12
columns, one for each month. See example.

J F M A M J J A S O
N D (months)
Donor 1 year 1
year 2
year 3
Donor 2 year 1 (etc)

I have tried a crosstab query but Can't seem to figure it out. The
information comes from 2 different tables that are related.

Any help would be greatly appreciated.

 

[Duane Hookom]

If the "2 different tables" confuses you then save a query based on the 2
tables. Then create a crosstab query based on the first query. You would use
Donor and Year([YourdateField]) as Row Headings,
Format([YourdateField],"mmm") as the Column Heading, and Sum([Amount]) as
the value.