lcSql = "SELECT po_d.rcv_numb, po_d.por_numb, po_d.ven_numb, po_d.usr_code, cTemp.nRcv_totl ; FROM (SELECT po_d.rcv_numb, SUM(po_d.por_txam + po_d.por_ntam) AS nRcv_totl FROM po_d GROUP BY po_d.rcv_numb) AS cTemp ; INNER JOIN po_d ON cTemp.rcv_numb = po_d.rcv_numb ; ORDER BY po_d.rcv_numb " =ExecuteSql(lcSQL, "cPo_d")Thank You for the tip.