Search results
-
H
Update rows with the sums of fields from other table
Hi, I have to update tempqty of all available products in the productlist. For this I have to calculate the difference of the Sums of each product purchased and sold from Inventory. I am writing this query for the same in MS access but is not working: UPDATE CopyProductBatch AS p SET...