PRIVATE lnCount, lnSum lnCount = 1 lnSum = 0 SELECT cod, name, deb, cre, RunningBalance(deb-cre) AS nBalance FROM Test FUNCTION RunningBalance LPARAMETER tnValue *-- User Defined Function that allows calculating running totals. *-- Adds tnValue to lnSum. *-- Assumes that the following variables are inititalized before *-- the SQL SELECT command: *-- PRIVATE lnCount, lnSum *-- lnCount = 1 *-- lnSum = 0 IF lnCount > 1 lnSum = lnSum + tnValue ELSE *-- skip first call (called by SQL parser) lnSum = 00000000.00 ENDIF lnCount = lnCount + 1 RETURN lnSumSee also Message #534436 for additional info about calling UDFs from SQL SELECT.