Update Query Question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hello all,

Can anyone tell me how to use the Instr() function to change all occurances
of the word "Trm" to the word "Term" using an update query.

-Sky
 
I'm not sure why you want to use Instr() and a query. If this is a one time
task, open the table in datasheet and use the Edit menu to find and replace.

You might be able to use the Replace() function in an update query.
 
Back
Top