any way thank you for help.

For my question I got it as I told you in previous post.

Thank you again.

I'm trying to connect from Vb2005 to Ms Access

and here is the solution for my Question

" SELECT B,C,D,E,SUM( IIF(A='Buy', F, -F,) ),LAST(G),LAST(H) FROM Table1 Where A IN ('Buy','Sell','Damage') GROUP BY...

MS access.

Yes, DBAccess and I'm using one Table

Is this correct?

SELECT B,C,D,E, UNION(SELECT B,C,D,E, SUM(F) Where A='Buy' GROUP BY B,C,D,E ") +((SELECT B,C,D,E, SUM(F) Where A='Sell' GROUP BY B,C,D,E ")-(SELECT B,C,D,E, SUM(F) Where A='Damage' GROUP BY B,C,D,E...