Bill,

You cannot use expression in the GROUP BY clause if it doesn't evaluate to column number.
Change expressions to column names in GROUP BY: DTOS({06/04/2003}) to postdate, PADR(ALLTRIM(details),40) to details, e.t.c.

>Well I'm sure it's something stupid but...
>
>This select will not run because it says the group by clause is missing or invalid. If someone would be so kind as to tell me what I'm missing I would really appreciate it.

>SELECT recordtype, importaccountid, DTOS({06/04/2003}) postdate, ;
>	effectivedate, transactiontype, dbcr, ;
>	SUM(IIF(dbcr = 'C', -1 * VAL(amount), VAL(amount))) amount, ;
>	ref1, ref2, ref3, ref4, ref5, PADR(ALLTRIM(details),40) , ;
>	scvind, name, company, phone, SPACE(20) email, SPACE(15) fax, ;
>	property, address1, address2, city, state, filler, zip, country, ;
>	filler2 ;
> FROM cwtsdata ;
> GROUP BY recordtype, importaccountid, DTOS({06/04/2003}), effectivedate, ;
> 	transactiontype, dbcr, ref1, ref2, ref3, ref4, ref5, ;
> 	PADR(ALLTRIM(details),40), scvind, name, company, phone, SPACE(20), ;
> 	SPACE(15), property, address1, address2, city, state, filler, zip, ;
> 	country, filler2 ;
> INTO CURSOR CashwiseTerminalServicesData