update query in SQL

[Sleekmac]

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

 

[FoFa]

AND F5 IS NULL

Also your Interp rates should be enclosed in brackets as such [Interp rates] since it contains a space, same with Next Rate

 

[Sleekmac]

Thanks! I knew it was something simple like that.