Iterating SQL statement By For Loop (MS Access) <p>In my test database, I am attempting to do an iterative <code>UPDATE</code> statement based on multiple criteria. </p> <p>In my table I am trying to update, <code>tblSales_Language</code>, I have the columns<br> <code>Sales _LanguageID , Language_ID, Sales_CountryID, SalesID, &amp; CountryID</code></p> <p>As a reference table, I am using <code>tblSales_Country</code>, which has <code>Sales_CountryID, CountryID, SalesID</code>. </p> <p>My goal is to <code>UPDATE</code> the columns in tblSales_Language, which have information but all columns except for <code>Sales_CountryID</code>- this information I am attempting to draw from the reference table <code>tblSales_Country</code></p> <p>Without further ado, my current code is as follows:</p> <pre><code>Dim i as integer Dim SQL As String For i = 1 to 5 SQL = "UPDATE tblSales_Language &amp;_ SET tblSalesLanguage.SalesCountryID = " &amp; DLOOKUP("Sales_CountryID", "tblSales_Country", "[SalesID]" = i)" Exit For </code></pre> <p>My code does not register as syntactically correct, does it have to do with the fact that I do not have a <code>WHERE</code> in my statement?</p> <p>Thanks.</p>