>>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
Try a comma instead of a plus. My bad..
Bret Hobbs
"We'd have been called juvenile delinquents only our neighborhood couldn't afford a sociologist." Bob Hope
