How do you sum column values on a results page after a search query?

I have a page that stores client contracts and need to be able to sum numeric data on specific columns after a search query on the results page. This would be similar results to the total records found after a search (a basic dreamweaver function). Please let me know if you can assist. I've included my results page with the search form within the same page.

Thanks.

use the SUM function in your query:

http://www.tutorialspoint.com/mysql/mysql-sum-function.htm

Thanks Jason. The problem I'm encountering is when I add a SUM function, it only returns 1 record. If I add a GROUP BY function such as the contract ID (npc_id), It doesn't SUM up the column values like my bag quantities (bag_qty). I attached the file I'm working on to the previous post but here is my SQL statement for the recordset I'm looking to get SUM results on.

"SELECT *,SUM(bag_qty) as TotalBags, (bag_qty*bag_weight) as TotalKg, (landed_price*2.2046) as KGprice, (bag_qty*bag_weight*2.2046*landed_price) as TotalContractPrice, Coalesce((twenty_five_paid_ci+spot+seventy_five),0) as BalanceDue FROM npc_contract LEFT OUTER JOIN clients ON npc_contract.client_id=clients.ClientID LEFT OUTER JOIN inventory ON npc_contract.coffee_id=inventory.inventory_id LEFT OUTER JOIN warehouse ON npc_contract.destination_port=warehouse.WarehouseID LEFT OUTER JOIN np_agents ON npc_contract.agent=np_agents.agentID WHERE inventory_year >= '2013' ORDER BY npc_id DESC"

The example above is just testing the SUM function of the bag quantites: SUM(bag_qty) as Total Bags. What I want to be able to do is sum the total values of certain columns after I have preformed a search.

Thanks Jason.

yes, the sum function will only return the one sum result.

I would use 2 recordsets, one with the sum function, and a second with the other information in it.

Makes sense. One more question. If I'm performing a search and want to show the results of the search with both recordsets, how do I search them at the same time?

Thanks!

2 instances of data assist search, one for the first recordset, the second for the second recordset.

Great. I'll give it try. Thanks for your quick response.