Sleekmac
Registered User.
- Local time
- Yesterday, 23:22
- Joined
- Sep 25, 2006
- Messages
- 34
Does anybody see anything wrong with this Update query please?
mySQL2="UPDATE Interp rates SET Interp Rates.Next Rate=nextrate WHERE (((F1)='ZAR')and (isnull(F5)=True))"
(The table is [Interp Rates], the field I want to update is [Next Rate], and the set is any record where [F5] is Null and where [F1] is "ZAR".
When it encounters the doCmd runSQL2, it returns "Syntax error in UPDATE statement."
Thanks in advance!
Don
mySQL2="UPDATE Interp rates SET Interp Rates.Next Rate=nextrate WHERE (((F1)='ZAR')and (isnull(F5)=True))"
(The table is [Interp Rates], the field I want to update is [Next Rate], and the set is any record where [F5] is Null and where [F1] is "ZAR".
When it encounters the doCmd runSQL2, it returns "Syntax error in UPDATE statement."
Thanks in advance!
Don
Last edited: