Hi Amad, this can be done with a SQL-Statement similar to SELECT SUM(item_cost) from Mydatabase or even more complicated as
SELECT SUM(item_cost * Ordered_Pieces) AS BackLook from MyDatabase WHERE item_number <= 0 Have fun Bob *********** Am 07.05.2009 11:11:26 schrieb ihnen Ahmad $arhan **** <[email protected]> *************** > dear all > > how can I get sum of <item_cost> that retrived from query > > i mean > > sql query is retriving some fileds one of them is item_cost,, i need to > make new query to calculate the summation of the item_cost > > > thanx for reading and the comming thanx is for reply the solution :) > > ------------------------------------ ----------------------------------------------------- Home page: http://groups.yahoo.com/group/delphi-en/ To unsubscribe: [email protected]! Groups Links <*> To visit your group on the web, go to: http://groups.yahoo.com/group/delphi-en/ <*> Your email settings: Individual Email | Traditional <*> To change settings online go to: http://groups.yahoo.com/group/delphi-en/join (Yahoo! ID required) <*> To change settings via email: mailto:[email protected] mailto:[email protected] <*> To unsubscribe from this group, send an email to: [email protected] <*> Your use of Yahoo! Groups is subject to: http://docs.yahoo.com/info/terms/
