Hi Michel...

As per you advice, I tried you code. It worked in a simple test. But the following code gave me a syntax error. Could you please look @ it and tell me where I am going wrong...

CLOSE ALL
DO PATH
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, MAX(po_d.rcv_numb) AS PrimaryKey, 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 "

lnRtnValue = SQLEXEC(gnC, lcSQL, "cPo_d")

Thank You...

Raza Malik