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 T1Creates one record into FPD26, with all the totals I need, but in VFP9 I get group by clause is missing or invalid.