Heidestrand
Registered User.
- Local time
- Today, 05:55
- Joined
- Apr 21, 2015
- Messages
- 73
Hey community (and a happy new year to all of you),
I need your help for a simple problem: I want to calculate the balance for each order number I have in my table. If the result is = 1 it should set the value = true in column "won" (it's a yes/no column).
So I've coded something like this:
But it's not completely working, it gives me a syntax error.
Do you know where the problem is?
I need your help for a simple problem: I want to calculate the balance for each order number I have in my table. If the result is = 1 it should set the value = true in column "won" (it's a yes/no column).
So I've coded something like this:
Code:
UPDATE tblFinalOrder
SET won = true
WHERE '1' EXISTS (SELECT Sum(tblFinalOrder.System_AEMenge) AS Sum, tblFinalOrder.SAPNr
FROM tblFinalOrder
GROUP BY tblFinalOrder.SAPNr);
Do you know where the problem is?
Last edited: