Topic: Math-calcul
Hi everybody,
how i can i do subtraction of the result of a Sum (Total) and the result of another Sum (total),
it's for a takings project.
Thank You
My Visual Database → Talks about all → Math-calcul
Hi everybody,
how i can i do subtraction of the result of a Sum (Total) and the result of another Sum (total),
it's for a takings project.
Thank You
Hello.
The answer depends on exactly where you want to see the result?
On of the options
var
s: string;
begin
s := SQLExecute ('SELECT TOTAL(field1) FROM TableName1') - SQLExecute ('SELECT TOTAL(field2) FROM TableName1');
ShowMessage(s);
here is an example :
thanks in advance
Example
function CalculateFooters: double;
begin
result := Form1.TableGrid1.Columns[0].Footer.FormulaValue - Form1.TableGrid2.Columns[0].Footer.FormulaValue;
end;
procedure Form1_TableGrid2_OnChange (Sender: TObject);
begin
Form1.Label1.Caption := FloatToStr(CalculateFooters);
end;
procedure Form1_TableGrid1_OnChange (Sender: TObject);
begin
Form1.Label1.Caption := FloatToStr(CalculateFooters);
end;
Thank you! I'll try
HI,
DriveSoft here is the file,
My question is in this image
Unfortunately you use cracked version of application. Support on the forum only for legal users.
yes sir
Sorry that, Dimtry!
i'll buy your software.
But i realy need your help to understand.
Thanks
My Visual Database → Talks about all → Math-calcul
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi