Thank you for your respohse. I have not seen Coalesce before.

Firebird 1.5 balks at the "Select" in the 3rd line "Token unknown, line 3, char 5."

> SELECT
> COALESCE( PI.Balance,0) + COALESCE(
> SELECT(PAI.Balance) FROM PersonActInfo PAI where PAI.Person_ID

^^^^^^

Ed Dressel