>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
OK thanks...I have been told to do this in the vfp60 report writer.
I need to display 1999 data and 2000 data in the detail line..
I think I need to write code for the report and just display the results in a viewer. what to you think?