Thanks..One more problem

[r_p]

Hi,

daily_trans
===========

SCRIP_CODE SCRIP_NAME CLIENT_CODE QTY B_S d_t cost
---------- ---------- ----------- ---------- ----------
500100 TISCO 47198 1000 BUY 10/10/2005 100.10
500100 TISCO 47198 1000 SELL 12/10/2005 101.10
500101 RELCAPITAL 47198 1000 BUY 10/10/2005 102.10
500101 RELCAPITAL 47198 1000 SELL 12/10/2005 103.10
500102 RELIANCE 47198 1000 BUY 15/10/2005 104.10
500103 SATYAM 47198 2000 BUY 15/10/2005 105.10
500101 RELCAPITAL 47198 1000 BUY 16/10/2005 110
500101 RELCAPITAL 47198 1000 BUY 17/10/2005 120

master
======

client_code client_name email
------------ ---------- -------
1002 abc a@gmail.com



SELECT master.[client_name], master., daily_trans.[scrip_code], daily_trans.[scrip_name], daily_trans.[client_code], sum(IIf([b_s]='BUY',[qty],0))-sum(IIf([b_s]='SELL',[qty],0)) AS net
FROM daily_trans ,master
where daily_trans.[client_code] = master.[client_code]
GROUP BY daily_trans.[scrip_code], daily_trans.[scrip_name], daily_trans.[client_code],master.[client_name], master.[email]
HAVING sum(IIf(b_s='BUY',qty,0)) - sum(IIf(b_s='SELL',qty,0)) <> 0;


Giving output as,

CLIENT_NAME EMAIL SCRIP_CODE SCRIP_NAME CLIENT_CODE NET
---------- ---------- ----------- ---------------------
abc [email]a@gmail.com 500102 RELIANCE 1002 1000
abc a@gmail.com 500103 SATYAM 1002 2000
abc a@gmail.com 500101 RELCAPITAL 1002 2000


But i want the o/p as, (Cost field is necessary)

CLIENT_NAME EMAIL SCRIP_CODE SCRIP_NAME CLIENT_CODE COST NET
---------- ---------- ----------- ---------------------
abc a@gmail.com 500102 RELIANCE 1002 104.10 1000
abc a@gmail.com 500103 SATYAM 1002 105.10 2000
abc a@gmail.com 500101 RELCAPITAL 1002 115 2000

How can i solve this problem?

Thanks Rathish