Search results
-
H
Update rows with the sums of fields from other table
Galaxiom - Can you suggest how to frame this query in query designer? The designer looks scary. I am using access 2010 and 2002-2003 mdb file format -
H
Update rows with the sums of fields from other table
Thanks Galaxiom for the revision, but I had already tried it in your previous post. Not working :( Its really silly of Access not to execute query that works cool in MySQL. @Banana - Thanks for the suggestions. I think going with the temporary table idea is better because only 1 query needs... -
H
Update rows with the sums of fields from other table
Hi Glaxiom, I tried this query but its not working. The error is "Syntax Error (missing operator) in query expression" I have tried several other different combinations of this query like converting it to SELECT but the same msg reappears. I have also tried changing the LEFT JOINS and the... -
H
Update rows with the sums of fields from other table
The MySQL query thats working for the above scenario is : UPDATE CopyProductBatch AS p LEFT JOIN (SELECT productbatchcode, SUM(qty) AS total FROM Inventory WHERE type = 'p' GROUP BY productbatchcode) AS a USING (productbatchcode) LEFT JOIN (SELECT productbatchcode, SUM(qty) AS total FROM... -
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...