Where is the missing operator?

[Ace]

Hi Everyone,

I'm stuck on an UPDATE sql command. I keep getting an error message that says that i'm missing an operator. I am trying to get the HighPoint to subtract from the Amount in the text matrix where the item number in rsItemNumber equals the text matrix Itemnumber. What is wrong with what I am doing?


rsItemBalance.Open "UPDATE ItemBalance SET HighPoint = HighPoint - " & msgViewToday.TextMatrix(1, 0) & " WHERE ItemNumber = " & msgViewToday.TextMatrix(1, 1) & "", _
cnn, adOpenStatic, adLockOptimistic

[Achichincle]

I think you have an extra set of quotes at the end of your statement.

[Bill Crawley]

It looks ok, it might be easier if you declared a string and moved the update command the the string and look at what is in the string value, it may be clearer if you see what the update command actually says (i.e. your matrix values may be empty)