<div>
You can use below code<br />
<br />
Go to MS Access Design View - &gt;&nbsp;SQL View<br />
Paste below code<br />
<br />
<br />

<pre><code class="code-1 nolinks" id="code-8224636"><span>UPDATE Newsletter SET Uploaded=“Y” where [Story Type] &lt;&gt;&quot;The Ending&quot;</span>
</code></pre>
</div>


<div>
code syntax<br />

<pre><code class="code-1 nolinks" id="code-8224637"><span>Syntax </span>
<span></span>
<span>UPDATE [Tablename] SET Fieldname=“Y” where [Fieldname] criteria</span>
<span></span>
<span>then should be</span>
<span></span>
<span>UPDATE Newsletter SET Uploaded=“Y” where [Story Type] &lt;&gt;&quot;The Ending&quot;</span>
</code></pre>
</div>


<div>
brilliant - thank you for that
</div>


<div>
<div class="content wysiwyg-content">
Dear Experts<br />
<br />
I need to find the most efficient way of updating records on mass. &nbsp;What I am trying to achieve is to update records in a table that meet a certain criteria. The table is linked to a sharepoint 2010 list (but this shouldn't make any difference (I hope))<br />
<br />
The fields involved are as follows:<br />
<br />

<div class="bullet">
Table = “Newsletter”
</div>
<br />

<div class="bullet">
Field to update = &nbsp;“Uploaded” (a Yes/No field)
</div>
<br />

<div class="bullet">
Criteria Field = “Story Type” (Text) - where &lt;&gt;&nbsp;“The Ending”
</div>
<br />
So the statement would be to mark “Uploaded” as Yes except if Story Type = “The Ending”<br />
<br />
The table will grow on average by 2,000 records a year, but each time this code is run there is likely to only be 30-40 records that need updating.<br />
<br />
Can anybody help?<br />

</div>
</div>


Dear Experts

I need to find the most efficient way of updating records on mass.  What I am trying to achieve is to update records in a table that meet a certain criteria. The table is linked to a sharepoint 2010 list (but this shouldn't make any difference (I hope))

The fields involved are as follows:

Table = “Newsletter”

Field to update =  “Uploaded” (a Yes/No field)

Criteria Field = “Story Type” (Text) - where <> “The Ending”

So the statement would be to mark “Uploaded” as Yes except if Story Type = “The Ending”

The table will grow on average by 2,000 records a year, but each time this code is run there is likely to only be 30-40 records that need updating.

Can anybody help?


Update Table

Microsoft Access is a rapid application development (RAD) relational database tool. Access can be used for both desktop and web-based applications, and uses VBA (Visual Basic for Applications) as its coding language.