<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 id="code-8224636">UPDATE Newsletter SET Uploaded=“Y” where [Story Type] &lt;&gt;&quot;The Ending&quot;</code></pre>
</div>


<div>
code syntax<br />

<pre><code id="code-8224637">Syntax 

UPDATE [Tablename] SET Fieldname=“Y” where [Fieldname] criteria

then should be

UPDATE Newsletter SET Uploaded=“Y” where [Story Type] &lt;&gt;&quot;The Ending&quot;</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?


You can use below code

Go to MS Access Design View - &gt; SQL View
Paste below code



Update Table

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&#39;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 &lt;&gt; “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?


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.