Hi Randy,
>Hi Randy,
>>With "Set EngineBehavior 80/90" is necessary that ALL fields be in Group By clause and that Memo fields are not allowed.
>>For solve your problem, you can to do a "Set EngineBehavior 70" or you can to follow the rule above and you sould remove Memo's fields of Select clause and add the other fields (out Sum function) in Gorup By clause.
>>Good luck!>
>Thanks, I may need luck to fix this one. You are correct in the SET ENGINEBEHAVIOR is 90 - trying to be a good up-to-date programmer without reverting to old behavior. My late evening typos are corrected below. When you say Memo fields are not allowed - does that mean only in the GROUP BY or are they prohibited in the SELECT field list as well? I read the help and concluded that they should be left out of the GROUP BY. If I have to leave them out of the SELECT field list, I guess I'll have to generate this report cursor in two parts.....
>
>Thanks,
>
I saw that other members answered you.
Memo field can't be into Select statement if you are using Group By clause. You can to transform your Memo field with PadR() for sample (see Sergey answer).
Good luck!
Erick
Força Sempre!
Strength Always!