>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")
>
>

I still had this one in pending. I see you got several replies to it. So, I assume all is ok now.