Hi Sergey...

Yes, I think that is the problem. I am using VFP9.0 GROUP BY syntax with old ODBC. Listed below is the code I was using:

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.

Raza Malik