The setting of quotes seems completely wrong to me.
Assuming fees is numeric and you want to subtract the value in AdjyustAmount.Text then I'd say it should look like:
Code:SQL = "update TBL_TEST_LIB set FEES= & (fees - Val(AdjustAmount.Text) & ";"
| CodeGuru Home | VC++ / MFC / C++ | .NET / C# | Visual Basic | VB Forums | Developer.com |
|
Results 1 to 13 of 13
Thread: Big ProblemThreaded View
|
Click Here to Expand Forum to Full Width |