Posted by tzuriel on 08/31/06 14:56

Thanks for the suggestion. Would you be able to offer some code for
consideration? I tried something like this at one point but couldn't
get it to work.

Thanks,

Tzuriel
frothpoker wrote:
> two queries would be easier but obviously has a bigger overhead.
>
> You could do the following:
>
> Set $CurrentYear as the yearID from the first row
>
> on each time through the loop, check YearID against $CurrentYear and if
> it is not the same then end the table and start a new one before
> setting $CurrentYear to the yearID of the current row.
>
>
>

[Back to original message]