<div>
Other approach: to avoid hard coding the query.<br />
<br />
Create a table u(f, t) with entries from id to id<br />
<br />
f &nbsp; &nbsp; &nbsp; &nbsp; &nbsp;t<br />
8265 8309<br />
------ &nbsp;------<br />
<br />
UPDATE &nbsp;equipment &nbsp;inner join u on equipment .local_indicator_id=u.f<br />
set equipment .local_indicator_id =u.t
</div>


Other approach: to avoid hard coding the query.

Create a table u(f, t) with entries from id to id

f          t
8265 8309
------  ------

UPDATE  equipment  inner join u on equipment .local_indicator_id=u.f
set equipment .local_indicator_id =u.t

<div>
<div class="content wysiwyg-content">
How can I do something like below in MS access, where I'm updating a record in the &nbsp;equipment table based on a related record in th e same equipment table. &nbsp; <br />
<br />
update equipment set local_indicator_id = (select local_id from equipment where id = 8309) &nbsp;<br />
where equipment.id = 8265
</div>
</div>


How can I do something like below in MS access, where I'm updating a record in the  equipment table based on a related record in th e same equipment table.   

update equipment set local_indicator_id = (select local_id from equipment where id = 8309)  
where equipment.id = 8265

MS access and Update/Select

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.