You just switched field names on me. Are you trying to confuse me? :)
BTW, do you want to include all acounts or only main accounts?

>That's correct! I've modified the statement and now it looks like this but for some reason I still don't get all the correct balances.
>
>

>Select A.Cuenta,A.Descripcion,
>Isnull((Select Balance From CNTBal03 Where Cuenta=A.Cuenta And Periodo=12 and Fiscal='2003' ),0)
>+Isnull((Select Sum(Debito-Credito) From CNTDET02 Where Cuenta=A.Cuenta And Periodo=1 And Fiscal='2004'),0)+
>Isnull((Select Sum(Debito-Credito) From CNTDET02 
Where Cuenta IN (Select Cuenta From CNTCuentas Where lTrim(rTrim(Descarga)) = 
lTrim(rTrim(A.Cuenta)) And Periodo=1 And Fiscal='2004')),0)
> As Balance, A.Descarga
>From cntCuentas A Order By rTrim(lTrim(A.Cuenta))
>
>

>