⑴ access2007 資料庫表進行一列求和
表為"num" ,金額列為"Mon",標示列為"Flag"SELECT Sum(Mon) AS ResFROM numWHERE (((num.[Flag])='T'));