How do I complete a mass edit?

[mkrylataya]

I have a table that includes a field for postal code. When the database was designed, the creator did not set the format rule for the field which resulted in inconsistent postal code format. Some records include postal code entered in the format "X1X1X1" while others have it entered as "X1X 1X1". Is it possible to create a query to find the records in the second format and remove the space in between so all the records show the postal code as "X1X1X1"?

Thank you in advance!

[orange]

Yes.

You could run an Update query to update the postal code.


Update tblYourTableName
Set PostalCode = Replace(PostalCode," ","")

BUT

Backup your database first. Do some testing before manipulating your production data.

[mkrylataya]

Thank you for your response!
I am a newbie and not sure how to exactly do it... Do I just input this as a code?