Adding up sums

This topic is locked

Adding up sums	12/21/2007 2:31:22 PM
PHPRunner General questions
S swanside author Hello again, I have created a master Detail setup, which shows the Job_No, Order_Time and other fields, I have made a custom view with the help of Jane and I am using this to generate an Invoice when the user selects Printer Friendly View. Here is the code. select job.Job_No, job.Order_Date, job.File_No, job.Order_Site_Address, job.Job_Description, job.Customer_Name, labour.Engineer_Name, material.Quantity, material.Unit_Price, material.Quantity Unit_Price + (Quantity Unit_Price Additional_Cost / 100), material.Description from job inner join labour on (job.Job_No=labour.Job_No) inner join material on (job.Job_No=material.Job_No) When the user clicks on the Basic_View and sees the information generated from the above code, there maybe 2 or 3 or more items of material. How can I add up all the results from the generated list of " material.Quantity Unit_Price + (Quantity Unit_Price Additional_Cost / 100), " to give a total? Thanks Paul.


S	swanside author 12/22/2007
	Hello again, I have created a master Detail setup, which shows the Job_No, Order_Time and other fields, I have made a custom view with the help of Jane and I am using this to generate an Invoice when the user selects Printer Friendly View. Here is the code. select job.Job_No, job.Order_Date, job.File_No, job.Order_Site_Address, job.Job_Description, job.Customer_Name, labour.Engineer_Name, material.Quantity, material.Unit_Price, material.Quantity Unit_Price + (Quantity Unit_Price Additional_Cost / 100), material.Description from job inner join labour on (job.Job_No=labour.Job_No) inner join material on (job.Job_No=material.Job_No) When the user clicks on the Basic_View and sees the information generated from the above code, there maybe 2 or 3 or more items of material. How can I add up all the results from the generated list of " material.Quantity Unit_Price + (Quantity Unit_Price Additional_Cost / 100), " to give a total? Thanks Paul. Its OK, I have sorted it now, Did it in SQL and used the TOTAL field.