SELECT Inventory.Inventory_Id, Inventory.Inventory_description, Inventory.Inventory_stock_count, nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty

FROM [Order]

WHERE Order.From_date<=Date() AND (Order.To_date)>=Date()

AND Order.Item_ID="I" & Inventory.Inventory_Id),0) AS CurrentlyOut, [Inventory_stock_count]-Nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty

FROM [Order]

WHERE Order.From_date<=Date() AND (Order.To_date)>=Date()

AND Order.Item_ID="I" & Inventory.Inventory_Id),0) AS NetHere

FROM Inventory;

my query1 = "SELECT Inventory.Inventory_Id, Inventory.Inventory_description, Inventory.Inventory_stock_count, nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty

FROM [Order]

WHERE Order.From_date<=Date() AND (Order.To_date)>=Date()

AND Order.Item_ID="I" & Inventory.Inventory_Id),0) AS CurrentlyOut, [Inventory_stock_count]-Nz((SELECT Sum(Order.item_qty) AS SumOfitem_qty

FROM [Order]

WHERE Order.From_date<=Date() AND (Order.To_date)>=Date()

AND Order.Item_ID="I" & Inventory.Inventory_Id),0) AS NetHere

FROM Inventory"





cmd.commadtext = myquery1



cmd.executenonquery()