Monthly/Yearly Reporting

[Guest]

Hi,
I have asked this question previously and followed some of the instructions,
but i cant get it to work out correctly. The fields i have in a table are
[Date Rec] and [Appl Ltr] and i want to do a monthly/yearly report by Date
Rec grouped by Appl ltr. I want this report to span horizontally and show
every years report.

For example,

Year 2000
Appl ltr Jan Feb Mar .. Dec Total
A 3 5 3 3 14
B 5 5 5 5 20
..

Year 2001
Appl ltr Jan Feb Mar .. Dec Total
A 5 4 1 10 20
..

....


Just like that.

I was directed to use a crosstab query and implement that into the report,
but that can either give me a report monthly or yearly, not both. I was
thinking about doing this with a Report/Subreport, but i cant figure out
exactly how to do it. Therefore if someone could help me, maybe provide an
example of some sort that would be great!

Thanks,
Tim

 

[Duane Hookom]

The crosstab should work. Set the Row Headings to both [Appl Ltr] and
Year([Date Rec]). The column heading would be Format([Date Rec],"mmm") and
the value is whatever (maybe a count).

Add another Row Heading that Counts or sums similar to your crosstab value.

Set the Column Headings property to:"Jan","Feb",..."Dec"