Microsoft Access REPLACE Function, Update Query, TechHelp Q&A

In today's lesson, I'm going to show you how to use the REPLACE function in an Update Query to change data in your tables. Specifically, we have a table with phone numbers in a bunch of random formats like: 716-555-4444, [phone], 239.444.3333, and so on. This lesson will show you how to make them all uniform like 2395551212.

TOPICS COVERED:
Replace Function
Update Queries

RESOURCES:

[greeniv]

I was trying to figure out how to update a table based on several calculated fields and this is the first video I've found that actually explains you have to make a second query and run that. THANKYOU so much!

[bradweekley]

Great short video! Combining the Replacement function with the Update query is so powerful. Thank you!

[FoxRivers]

I'm here because one day I decide to use parentheses in my data field and the next day I change my mind. I already know how to do it for one string but I want to remove both the right and left parentheses so I am here to learn to do it for multiple strings. I never would have thought to do it with a select query and update query. I've been making much use of the replace function so this video makes it even more useful.

[Wonderelijke_Wereld]

You have explained this very clearly. Thank you

[Jojifee]

Very practical lesson! Thank you very much, you just saved my day :)

[tessakapers]

Question, this does the job for all tabels wich contain this field name correct? If I have multiple tabels all with the same field name

[nicolasgunther]

Great video, thanks a lot!
I have a situation where I need to perform 42 replacements. Is there a way to do it all at once in 1 field rather than creating 42 intermediate fields?
Thank you.

[Liamhears]

Can you also add conditions? For example replace all X to Y except for data coming from the year 2018

[FerElsaflop]

I need to replace an unknown text before a character. For example: "Hello|Bye"
Result: "Bye|Bye". You helpme plis?

[ybudesureh]

Question: What if the original phone field is blank?

[giokc]

dude, how can i do that into a table field without Query.

a have a field with a short name and i want to replace a symbols for blank space, all into tha table field.

for example in desing mode: NameField = "Giova_nny"

then i want to replace "_" for blank space.
i try to use this code: Replace([NameField], "_", "")

i need help..