Hi,<BR>I&#039m trying to programm an UPDATE statement that simply increments the number in the "Counter"-Field by 1 with the following code:<BR><BR>mySQL="UPDATE Banner SET Counter=Counter+1 WHERE ID=" & Number<BR><BR>I am using an ACCESS-Database and I always get a "Syntax Error in the UPDATE statement".<BR>Counter is a LongInteger Field and ID is an autogenerated number by ACCESS.<BR>How do I have to change the code in order to work properly?