Monthly/Yearly Reporting

  • Thread starter Thread starter Guest
  • Start date Start date
G

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
 
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"
 
Back
Top