>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.....
The memo fields cannot be included 'as is' into GROUP BY query. You have to leave memo fields out of the list or convert them to character fields by wrapping into PADR() and including result columns into GROUP BY.
--sb--