> GROUP BY T.APPLET, T.INIT_ID, MOD( T.INIT_ID, 1000 )
> ORDER BY T.APPLET, 2
>
> Anyway, I think it isn't directly related to IBO, so ib-support
> might be the proper place for your problem.

Yes that fixed it. I suppose because I was not expecting the
'MOD' result to be different to INIT.ID I had not seen a
problem, but since there may be records from two teams for
one staff member, then this make sence. Just another fault
that Firebird now prevents me from making.

This code is still running with the IBO DLL's that have the
problem with FB1, so I was not sure if it was related to
that - hence asking here first.

Thanks - another eye always helps.

--
Lester Caine
-----------------------------
L.S.Caine Electronic Services