用Tquery做表 select sum(你要统计的列名) form yourTable 用Table procedure TForm1.Button1Click(Sender: TObject); var sd:integer;//sd为合计 begin with Table1 Do begin sd:=0; first; while not EOF do begin sd:=sd+Fields[3].value; next; end; end; Edit1.text:=IntToStr(sd); end;
或者用TQUERY 怎么做?
select sum(你要统计的列名) form yourTable
用Table
procedure TForm1.Button1Click(Sender: TObject);
var
sd:integer;//sd为合计
begin
with Table1 Do
begin
sd:=0;
first;
while not EOF do
begin
sd:=sd+Fields[3].value;
next;
end;
end;
Edit1.text:=IntToStr(sd);
end;