>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 >>
>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 >>