>Is that what you means? If so, there is an error "SQL:Grouping clause is missing or invalid"
>
>

>select case_no, eng_name, chi_name, SUM(charge) as sCharge, 
sum(IIF(Paid_Type="$", paid, 0.00)) as CASH, 
sum(IIF(Paid_Type="E", paid, 0.00)) as EPS, sum(IIF(Paid_Type="V", paid, 0.00)) as Credit, 
SUM(outstanding) as outstand;
> FROM income_log into cursor income_output group by 1 order by 1
>

>
>OR I need to put the eng_name, chi_name into grouping?!
>
>

>select case_no, eng_name, chi_name, SUM(charge) as sCharge, 
sum(IIF(Paid_Type="$", paid, 0.00)) as CASH, 
sum(IIF(Paid_Type="E", paid, 0.00)) as EPS, sum(IIF(Paid_Type="V", paid, 0.00)) as Credit, 
SUM(outstanding) as outstand;
> FROM income_log into cursor income_output group by 1,2,3 order by 1
>

>
>or is it a better way?!

What seems to be a problem with this one?