I have a function at the end of the program that summed the numbers. I’m trying to subtract the GrandPrice
with another field called Discount
.
x
UPDATE INV_Headers SET
GrandTotal = GrandTotal - Discount,
WHERE DocID = "xxxx"
But the error message (Syntax error in UPDATE statement access
) just popped-up, how do I update a field by subtracting the field with another?
EDIT: This question is due to a typo
Advertisement
Answer
Remove comma,
, if you want to update two column then use that comma ,
:
UPDATE INV_Headers
SET GrandTotal = GrandTotal - Discount
WHERE DocID = "xxxx"