Robert,

Another approach would be to join tables on Month. Works ok if there are only 2 or 3 years.

I did my reports with ThisYear, LastYear, PrevYear. At they beginning of the routine I determine

ThisYear = 2000
cThisYear = [FY] + ALLT(STR(ThisYear))
etc.

Then I select:
SELECT SUM(IIF(YEAR(dMyDate) = ThisYear, MyValue, 0.00)) AS ThisYearTotal, ;
SELECT SUM(IIF(YEAR(dMyDate) = LastYear, MyValue, 0.00)) AS LastYearTotal, ;
....
(for you, include MONTH() and group on MONTH(). )

and I use the cThisYear, cLastYear, cPrevYear in the headings on my report. Result is a totally generic report which doesn't have to be changed from year to year.


>>Otherwise, I am confused.
>Let me try again:
>
>Year Jan
>1999 jan data
>2000 jan data
>-end of detail band