<div>
you can achieve this in VBA using two recordsets. is this an option?
</div>


you can achieve this in VBA using two recordsets. is this an option?

<div>
capricorn1. &nbsp;I know VBA to certain extent. Would you create a Loop with one recordset into the other recordset? 
</div>


capricorn1.  I know VBA to certain extent. Would you create a Loop with one recordset into the other recordset?

<div>
Works great. &nbsp;Thank you very much
</div>


<div>
<div class="content wysiwyg-content">
I have two tables one table is called IC which has only two fields: &nbsp;Item# and Item_Description The other table which is a cross reference table called Abbreviation the Abbreviation table has two fields: Terms and Abbreviation. &nbsp; I need to search for the Terms from the Abbreviation table in the Item_Description field and replace the term in the Item_Description field with the abbreviation that corresponds with the Term.<br />
<br />
For expample, &nbsp;if the Item_Description is 5XLarge Tooth Picks and there is a Term in the Abbreviation tables called 5XLarge with a abbreviation of 5XL the Item_Description should change to 5XL Tooth Picks. &nbsp;The term could be anywhere in the Item_Description field. &nbsp;For example, the Item_Description could be 3 of 5XLarge Tooth Picks which should change to 3 of 5XL Tooth Picks. &nbsp;<br />
<br />
<br />

</div>
</div>


I have two tables one table is called IC which has only two fields:  Item# and Item_Description The other table which is a cross reference table called Abbreviation the Abbreviation table has two fields: Terms and Abbreviation.   I need to search for the Terms from the Abbreviation table in the Item_Description field and replace the term in the Item_Description field with the abbreviation that corresponds with the Term.

For expample,  if the Item_Description is 5XLarge Tooth Picks and there is a Term in the Abbreviation tables called 5XLarge with a abbreviation of 5XL the Item_Description should change to 5XL Tooth Picks.  The term could be anywhere in the Item_Description field.  For example, the Item_Description could be 3 of 5XLarge Tooth Picks which should change to 3 of 5XL Tooth Picks.  




Search and replace function query in MicroSoft Access

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.

Microsoft Access

SQL (Structured Query Language) is designed to be used in conjunction with relational database products as of a means of working with sets of data. SQL consists of data definition, data manipulation, and procedural elements. Its scope includes data insert, query, update and delete, schema creation and modification, and data access control.