... self-taught MS Access user, not familiar with VB but know my way around the Query design template.
I would like to create a query to update parts of a field. I have a text field from which I would like to remove "of" and "in" and "the". In reality I have a whole list of prepositions I need to remove but this is just an example.
For example: My table contains a field called [caption] where I would like would like to change the contents of a record from "Guido in the house of Guiseppe the Knee in Sydney" to "Guido house Guiseppe Knee Sydney"
Find and replace works just fine, but I need to run it repeatedly for each of the words I want to remove. I would therefore like to create a query which I can save for future use which lists all the various words I want to remove.