Topic: Count Tables
Ho how can count from 3 tables 3 records.
examples:
Table 1
Name
saleryA
Table 2
Name
saleryB
Table 3
Name
saleryC
Sum:= saleryA+saleryB+saleryC
My Visual Database → Script → Count Tables
Ho how can count from 3 tables 3 records.
examples:
Table 1
Name
saleryA
Table 2
Name
saleryB
Table 3
Name
saleryC
Sum:= saleryA+saleryB+saleryC
Please describe, where you want show the sum, in TableGrid? or in a textbox?
Both.
In the text box it should give also the sum of each tablegrid
Both.
In the text box it should give also the sum of each tablegrid
An example for you:
Yes this exactly what I was asking. Thank you.
I face another problem
I send you example.
There you will see 2 tables (MoneyA and MoneyB) they have a relationship with the Table Customer.
So what I want to do is When I press th TableGrid of The Form1 it should show in the TextBox the
Sum of MoneyA and MoneyB fr the Customer it is and not for all the customers.
I tried it wit the following script but it has faild
form1.TextBox1.value:= (Select Total(Sallery) from MoneyA where id=Id_Customer) + Select total(sallery) of MoneyB where id=id_Customer))
*I know that there is a mistake in the script so forgive me but I don't know SQL. I leran it together with MVDB
v_pozidis
Form1.Edit1.Value:= SQLExecute('SELECT (SELECT TOTAL(sallery) FROM MoneyA WHERE id_Customer='+Form1.TableGrid1.sqlValue+' ) + (SELECT TOTAL(sallery) FROM MoneyB WHERE id_Customer='+Form1.TableGrid1.sqlValue+')');
Thank you again for your help and the quick response.
My Visual Database → Script → Count Tables
Powered by PunBB, supported by Informer Technologies, Inc.
Theme Hydrogen by Kushi