Assuming that I have two tables in my database.
table: A
Sentence
Tom is a boy.
Mary is a girl.
table: B
BeforeWords|||AfterWords
Tom ||| Peter
Mary ||| Betty
is ||| was
After running the queries, it should have
Afteradjust
Peter was a boy.
Betty was a girl.
Table B is a converter which change a word into other.
I know Replace function query can be used... but it turns messy if i have over thousand of records.
How can transform it using VBA? (so weak in it!:banghead
table: A
Sentence
Tom is a boy.
Mary is a girl.
table: B
BeforeWords|||AfterWords
Tom ||| Peter
Mary ||| Betty
is ||| was
After running the queries, it should have
Afteradjust
Peter was a boy.
Betty was a girl.
Table B is a converter which change a word into other.
I know Replace function query can be used... but it turns messy if i have over thousand of records.
How can transform it using VBA? (so weak in it!:banghead
Last edited:
