>SELECT invnum, name, SUM(qty) AS qty FROM table GROUP BY Invnum+Name INTO cursor cursorname
This give me the folowing error:
"SQL: GROUP BY clause is invalid."
It appears that I can not use more than one field in the group by clause. Is this correct?
Einar
Semper ubi sub ubi.