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
.
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"