>From the VFP8 Help file:
>
>The GROUP BY clause does not support Memo or General fields.
>The GROUP BY clause must list every field in the SELECT list, except for fields contained in an aggregate function, such as the COUNT( ) function. In addition, the GROUP BY clause must also list every field in a HAVING clause, except for fields contained in an aggregate function.
>
>

I read the help file. I know I am missing something, I not sure what. Can some one please point out my mistake, oversight. I feel real dumb right now.

>
>
>>I have read the documentation and several articles. I still can not get the following code to work.
>>

>>lcReocrdRange = ' '     && in real code this is a calculation
>>Select building.name , ;
>>		master.roomnum , master.invnum , master.oldinvnb , ;
>>		master.objname , master.surdte , master.surdte2  , ;
>>		master.objmat  , ;
>>		master.objdesc , ;
>>		padr(reduce(CHRTRAN(CHRTRAN(master.objdesc , ;
>>			CHR(13),''), CHR(10),''), SPACE(1)),254)  AS desc , ;
>>		department.name  AS deptname  ;
>>	From master, building, department ;
>>	Where building.code = master.inscode ;
>>		AND department.code = master.deptcode ;
>>		&lcReocrdRange ;
>>	Group BY building.name  , ;
>>			 master.roomnum , ;
>>			 master.invnum    ;
>>	Into CURSOR antiqsum
>>

>>I get the an error message that Group by clause is invalid or missing. What am I missing?
>>
>>Any help appreciated.