> many many Thanx Alex, Bob,,, > > but i way tring to get the summation from an excuted query not from table > > like > select sum (item_cost) > from <query01> > > can you advice?
as much as i can understand, you want running summation of an open dataset/query. There are two ways to get this. 1. Attach a TDataSource to your DataSet/Query. Then OnDataChange event of the TDataSource you can calculate the sum of any column or whatever you want. This event will fire every time you do any thing to the DataSet/Query like moving from one row to other or edit/insert/delete etc. So you can calculate the running value of your required colum. 2. You can use third party component to get the sum like TDBSumList of ehLib (http://www.ehlib.com/ you can get an evalution version here). But I will recommend you to try the first one and if you have any further clarification or help. Post here we will try to help you. Thanks Iqbal
