update query 1

[peljo]

I want to build a query that updates the field branch4 to the field items4 and the sum obtained to divide to the field pack.My query cannot update can you help ?
Here is my query :
UPDATE products1 SET products1.branch4 = [products1].[items4]/[products1].[pack];

 

[PHV]

Perhaps this ?
UPDATE products1
SET branch4 = [items4]/[pack]
WHERE Nz(pack,0)<>0

Hope This Helps, PH.
FAQ219-2884
FAQ181-2886