macro for write in field on one table

  • Thread starter Thread starter Helder De Pinho
  • Start date Start date
H

Helder De Pinho

Hello

[I speak french, sorry for my english ...]

I have a table on my DB and I want to modify all the datas of one field.
I need the write some text before that was write on the field


en français :

bonjour,

je cherche à modifier tous les enregistrements d'un champ en concaténant
un autre bout de texte à ce qui est dans le champ.

Merci et meilleures salutations !
 
Helder,

You would use an Update Query for this. Update [YourField] to...
"Your new text " & [YourField]
Hope you will understand what I mean.

You can just run the Update Query to modify your data. If you need to
automate the process with a macro, you can use the OpenQuery action in
the macro.
 
Back
Top