replace the punctuation with blank

[Nick999]

Hi,

I have the address fields (addr1, addr2, city....) in table in access, i need to replace all punctuation (.,#@) in the above fields with blank, let say my table name is AddressTable.

Thanks,

[Rabbit]

You can use the replace function in an update query to do that.