Beth,

You can not have any aggregate fields (MAX, SUM, COUNT) without a Group by on all other non aggregate fields. You need to add to your Select a GROUP BY Client_ID clause

>Hi All,
>
>I have code in the aftercolchange method to set data up. Now I have a select that use to work, and is now, not working. It is Friday, I know, and I want to go home, so I can not see the problem with this select statement. I do not want to group the results. I am only looking at the first set of data returned.
>
>

>  SELECT client_id, MAX(act_time) FROM sup_act ;
>    WHERE client_id = lcclientid AND problem_id = lcproblemid ;
>    INTO ARRAY latemp
>

>
>I do not see where group by has any thing to do with the statement. Help!
>
>TIA
>Beth