Search and replace function query in MicroSoft Access
Posted on 2010-01-12
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.