用select sum(字段名) form tablename 或用计算字段(都挺简单) 建议你最好看看书
var i:Integer; TempSum:Double; begin TempSum:=0; for i:=1 to DbGrid1.DataSource.Dataset.RecordCount do begin TempSum := TempSum+DbGrid1.DataSource.Dataset.Fields[1].AsFloat; end;end;
或者是写SQL语句~~ with Query1 do begin close; SQL.Clear; SQL.Add('Select Sum(字段名) From 表名'); Open; end;
或用计算字段(都挺简单)
建议你最好看看书
i:Integer;
TempSum:Double;
begin
TempSum:=0;
for i:=1 to DbGrid1.DataSource.Dataset.RecordCount do
begin
TempSum := TempSum+DbGrid1.DataSource.Dataset.Fields[1].AsFloat;
end;end;
with Query1 do
begin
close;
SQL.Clear;
SQL.Add('Select Sum(字段名) From 表名');
Open;
end;