I have a field in my table with up to 10 abbreviations. I want to change all of those to complete words.
I have a table with 2 columns, the abbreviations and the complete words.
How should my Update query look when I want to change the stuff in to complete words.
I thinked about making different update queries for all the abbreviations, but there are over 25. It's just not an option.
Try this Update query and replace the following with your own table/field names:
tbl_Abbrev = table with your abbreivations and their long text
tbl_Text = table with field full of abbreviations
[TEXT] = field full of abbreviations
[ABBREVIATION] = abbreviation from tbl_Abbrev
[FULL_TEXT] = full text of abbreviation from tbl_Abbrev
UPDATE tbl_Abbrev, tbl_Text SET [tbl_Text].[TEXT] = Replace([TEXT],[ABBREVIATION],[FULL_TEXT])
Of course, be sure to make a backup copy of your table before updating it.