On Mon, Mar 07, 2005 at 10:43:37PM +0100, Henri-Damien LAURENT said:

Second look. It may be a great help. Many Thanks. --

I think this is the only way to get historical data, but for the future I see no reason not to add an issue_date field to the issues table. And store the date an item was issued in there. Chris -- Chris Cormack Programmer 027 4500 789 Katipo Communications Ltd chris@katipo.co.nz www.katipo.co.nz