Form design help (1 Viewer)

[aron.ridgway]

i need to run a condition that compares 2 field quantities together based on the same item. If they both equal the same then i want it to run a code and change a property for that record.

I will have a OrderQty and a Total receivedQty when these 2 equal each other then it updates the items Status to Received

what is the best way to accomplish this? in vba or queries/sql?

 

[BlueIshDan]

Update Query
W3Schools UPDATE

 

[BlueIshDan]

Your query will end up looking like

     UPDATE [table]
     SET status = "[something]"
     WHERE [field1] = [field2]

 

[aron.ridgway]

thanks for your suggestion, i have tried the following; the query is only readonly as it sums the recieve qty. So when i try and run the query i get a message 'Operation must use an updateable query' any way i could get round this?

UPDATE tblOrderDetail INNER JOIN qryReceiveRunningTotal ON tblOrderDetail.OrderDetailPK = qryReceiveRunningTotal.OrderDetailPK 
SET tblOrderDetail.Statusfk = 2
WHERE (((tblOrderDetail.qty)=[qryReceiveRunningTotal].[TotalReceive]));

 

[aron.ridgway]

i have solved this by creating a temp table to hold the summed qty, thaks for your help