J4amieC Moron

Thanks Nildari Biswas for Reply I appreciate for your answer. Thank you very much. But here i solved my problem please check. SELECT Item_Name, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail WHERE (Product.Item_Name = Item)) AS QuantityB, (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description WHERE (Product.Item_Name = Item)) AS QuantityC, (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail WHERE (Product.Item_Name = Item_Name)) AS QuantityD, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail AS tblB_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description AS tblC_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail AS tblD_1 WHERE (Product.Item_Name = Item_Name)) AS Total FROM Product GROUP BY Item_Name again Thanks for reply.

J4amieC This is the Correct one Still I am working On it to get some more Correct result, You Brain Less Idiot Look and think your self how u can say you are a developer, and by the way what are you doing here" "U think you can helping people" C ur self in the mirro U Idiot. and learn the manner how to speak with other. ''''''''''''''''''''''''''''''''''''''''''' Just to save time i asked question here. '''''''''''''''''''''''''''''''''''''''''' SELECT Item_Name, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail WHERE (Product.Item_Name = Item)) AS QuantityB, (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description WHERE (Product.Item_Name = Item)) AS QuantityC, (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail WHERE (Product.Item_Name = Item_Name)) AS QuantityD, (SELECT SUM(Piece_No) AS Quantity FROM Purchase_Detail AS tblB_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Detail_Description AS tblC_1 WHERE (Product.Item_Name = Item)) - (SELECT SUM(Itm_Qty) AS Quantity FROM Refund_Detail AS tblD_1 WHERE (Product.Item_Name = Item_Name)) AS Total FROM Product GROUP BY Item_Name

see ..!!! Now u are angry..You have to feel this. You have to think twise to tell some one like this " If you're incapable, I suggest you go back to your boss, hand him your keycard and tell him you are not qualified to be a developer. " OK. 1 - and by the way this is wrong answer, what kind of developer you are, each time how can user punch single product name to Check stock, There is million Productname in database. 2 - I just Give you crystal example from my first post. what is in database and what type of output i want, But you didnt understand (No Brain). Lol...I know what type of developer u are i dont need your wrong answer anymore just keep it with you. I will post correct one 2morrow. ''''''''''''

Danish your way to discuss is very good. you understand the fault of my first post. and you mentioned it on very nice way, i understand and thanks to explain me. But i am sorry Danish i just dont like the way of other helps.

tell me broo why we are here, why peoples are posting his problem here...? for to hear this " Go to your boss and tell him you are not qualified developer " ?? Before i posted this problem i already tried above query and thats why i asked question here ? I am also replying answer from other forums also.. i know how to answer and how to reply. I am telling anyone who is asking so stupid question like this. But i am replying them. i think you understand what i mean to say.

Hey.. Where are you Mr. J4amieC.. If you are capable answer this ... Else....You know what...

I Tried this also but not getting right total. ''''''''''''''''' SELECT Prd.Item_Name, Sum(P.Piece_No) AS PStock, Sum(D.Itm_Qty) AS SoldStock, Sum(R.Itm_Qty) AS RefStock, Sum(P.Piece_No)-Sum(D.Itm_Qty)-Sum(R.Itm_Qty) AS Avl_Stock FROM Refund_Detail AS R, (Product AS Prd INNER JOIN Purchase_Detail AS P ON Prd.Item_Name = P.Item) INNER JOIN Detail_Description AS D ON Prd.Item_Name = D.Item WHERE (((Prd.Item_Name)=[P].[Item] And (Prd.Item_Name)=[d].[Item])) GROUP BY Prd.Item_Name;

Thanks for reply i.j.russell if i am using this WHERE Prd.Item_Name = P.Item and Prd.Item_Name = d.Item and Prd.Item_Name = R.Item_Name Its just giving me Refunded items with wrong total,

'''I tried this following Query but it giving me wrong total what i am missing in following query SELECT Prd.Item_Name, sum(P.Piece_No) AS PStock, sum(D.Itm_Qty) AS SoldStock, sum(R.Itm_Qty) as RefStock, sum(P.Piece_No) - sum(D.Itm_Qty) - sum(R.Itm_Qty) AS Avl_Stock FROM Product AS Prd, Purchase_Detail AS P, Detail_Description AS D, Refund_Detail as R WHERE Prd.Item_Name=P.Item GROUP BY Prd.Item_Name;

[Message Deleted]

[Message Deleted]

Hello Experts i am working on a VB 6.0 Project i am using Datacombo1 and a Text box, what i want that when i am typing in text box datacombo1 must Highlighted matched items. How can i do that. Your Help will be appreciated. :(

Thanx Vinod i hope that it will solved

Thanks Mr. Christian

Hi all anyone can help me Please i have some problem to transfer data from vb application to excel file textbox value into excel cell. i open excel file by using shell command but after open file how to add data from vb application to excell without delete or replace previouse data. here is shell coding. Dim Book1 As String Dim Directory As String Dim Program As String Directory = Book1 Program = "C:\Program Files\Microsoft Office\Office11\Excel.exe " Book1 = (Directory & "\Export") Shell (Program & Book1) Thanks for advance ___________ Khan786 -- modified at 6:56 Thursday 21st June, 2007