<div>
Create a TOP 100 Select query first to limit the recs, then ... create a Update query that Joins on that query - so that only 100 recs will be affected. &nbsp;Or, use a WHERE clause with the IN operator to 'join' on that query.<br />
<br />
mx
</div>


Create a TOP 100 Select query first to limit the recs, then ... create a Update query that Joins on that query - so that only 100 recs will be affected.  Or, use a WHERE clause with the IN operator to 'join' on that query.

mx

<div>
Thanks. Have not used a WHERE &nbsp;IN statement. Thanks for spelling in out.
</div>


Thanks. Have not used a WHERE  IN statement. Thanks for spelling in out.

<div>
<div class="content wysiwyg-content">
Hello Experts,<br />
<br />
I have a table (tblReg) that I wish to Update a field named &quot;flag&quot; to Yes. I only want to Update the TOP 100 records. I realize that the property Top Values is available only for a Select query not available for an Update query.<br />
<br />
How can I simply Update this field from No to Yes with the criteria being only the first 100 records?<br />
It does not matter which records, just 100 of them.<br />
<br />
Thanks &nbsp; &nbsp;<br />
Jim
</div>
</div>


Hello Experts,

I have a table (tblReg) that I wish to Update a field named "flag" to Yes. I only want to Update the TOP 100 records. I realize that the property Top Values is available only for a Select query not available for an Update query.

How can I simply Update this field from No to Yes with the criteria being only the first 100 records?
It does not matter which records, just 100 of them.

Thanks    
Jim

Update Top n Records

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.