"SELECT COUNT(*) AS TOTOALNUMBER FROM ATable ”怎样才能的到记录的总数？我用的是DAO查ACCESS

CDaoDatabase db; //数据库
CDaoRecordset RecSet(&db); //记录集
    
    COleVariant var; // 字段类型
var.ChangeType(VT_BSTR, NULL);m_Sql="SELECT  COUNT(*) AS TOTOALNUMBER FROM ATable ";RecSet.GetFieldValue( "TOTOALNUMBER", var );
CString  TOTOALNUMBER1= (LPCSTR)var.pbstrVal;
           
AfxMessageBox(TOTOALNUMBER1);//为什么TOTOALNUMBER1总是为空呢