出学者的求助:查询统计问题

UpdateData();
  if(!m_lnum.IsEmpty()&&!m_snum.IsEmpty())
  {
  _variant_t vje;
          CString sql,je,message;
  
         sql.Format( "SELECT je FROM cc where lnum=%s and snum=%s" , m_lnum ,m_snum); try
{
m_pRecordset.CreateInstance("ADODB.Recordset");
m_pRecordset->Open((_variant_t)sql,_variant_t((IDispatch*)theApp.m_pConnection,true),adOpenStatic,adLockOptimistic,adCmdText);
if(m_pRecordset->adoEOF)
MessageBox("No Information!","信息提示",MB_ICONINFORMATION);
else
{
vje=m_pRecordset->GetCollect("je");
    je=(char*)_bstr_t(vje);
message.Format("赔偿金额:%s元",je);
        MessageBox(message,"信息提示",MB_ICONINFORMATION);
}

}
catch(_com_error e)///捕捉异常
{
CString errormessage;
errormessage.Format("错误信息:%s",e.ErrorMessage());
AfxMessageBox(errormessage);///显示错误信息
}
  }
  else
  AfxMessageBox("请输入信息!!!");
楼号     宿舍        金额
1        123         12  
1        123         23
1        123         32
怎样把金额加起来