See section on 'GROUP BY' under "SET ENGINEBEHAVIOUR" in help.
Regards,
Viv
>Hi
>
>I am trying to transfer an SQL statement from a FPD26 program into VFP9, but the command doesnt seem to work
>
>

>Select customer.name, customer.code, COUNT(*), SUM(ord_tot - vat) AS value,
>SUM(IIF(orders.o_type $ 'ABCDPS', 1, 0)) AS paid, SUM(IIF(orders.o_type
> $ 'ABCDPS', 0, 1)) AS unpaid, SUM(orders.adw) AS s_adw, SUM(carriage) AS s_carr, SUM(vat) AS s_vat FROM ORDERS,CUSTOMER WHERE orders.ent_date<
> (entdate) AND BETWEEN(orders.fun_date, (f_start), (f_end)) AND customer.code = orders.customer AND customer.custgroup = what INTO CURSOR T1

>
>Creates one record into FPD26, with all the totals I need, but in VFP9 I get group by clause is missing or invalid.
>
>Any help extremley appreciated