Kathyrlcrs
MIS
I am using 8.5 with an access database.
This is a report for a count using a date field. We are just counting how may date records are there. Pretty simple.
The following is the report I have:
2003
MONTH YTD
January 15 15
February 12 27
March 11 38
April 10 48
May 16 64
June 5 69
July 11 80
August 14 94
September 10 104
October 16 120
November 14 134
December 12 146
Total for 2003 146
2004
MONTH YTD
January 10 10
February 21 31
March 11 42
April 6 48
May 9 57
June 5 62
July 9 71
Total for 2004 71
I would like to put the information side by side on the report for comparison reasons.
I have tried using a cross tab, but am having problems because I can't use a running total in a cross tab. Am I missing something in how to do this?
Any insight or suggestions would be appreciated.
Thank You!
This is a report for a count using a date field. We are just counting how may date records are there. Pretty simple.
The following is the report I have:
2003
MONTH YTD
January 15 15
February 12 27
March 11 38
April 10 48
May 16 64
June 5 69
July 11 80
August 14 94
September 10 104
October 16 120
November 14 134
December 12 146
Total for 2003 146
2004
MONTH YTD
January 10 10
February 21 31
March 11 42
April 6 48
May 9 57
June 5 62
July 9 71
Total for 2004 71
I would like to put the information side by side on the report for comparison reasons.
I have tried using a cross tab, but am having problems because I can't use a running total in a cross tab. Am I missing something in how to do this?
Any insight or suggestions would be appreciated.
Thank You!