hey guys
i have a new query, pls look at the tables below,
<p>
Basically a specified transaction may have many items, once the items are added into the "transactions table" i would like to calulate the total for a specified transaction,
for example in the table shown below i would like to select the "calculate total" button and what this shud do
is add up all the prices(named pr in the table) for a specified transaction from the price column,
<p>
lets say for example trans 22 as shown in the table called "transaction", and the sum of the prices for transaction 22 should
be put in the TOTAL table in the field called Total along wid the number of the specified transaction as shown in the screen shot, then the total for this specified transaction shud be put on the label called TOTAL as shown in the screen shot.
any ideas how do do this im really stuck i have tried but im not having much luck!
pls could someone help me, its for a project and urgently needed!
kind regards
Sam
i have a new query, pls look at the tables below,
<p>
Basically a specified transaction may have many items, once the items are added into the "transactions table" i would like to calulate the total for a specified transaction,
for example in the table shown below i would like to select the "calculate total" button and what this shud do
is add up all the prices(named pr in the table) for a specified transaction from the price column,
<p>
lets say for example trans 22 as shown in the table called "transaction", and the sum of the prices for transaction 22 should
be put in the TOTAL table in the field called Total along wid the number of the specified transaction as shown in the screen shot, then the total for this specified transaction shud be put on the label called TOTAL as shown in the screen shot.
any ideas how do do this im really stuck i have tried but im not having much luck!
pls could someone help me, its for a project and urgently needed!
kind regards
Sam