Paul,
If doping it ion an Update Query, you would update [zip] to...
Replace([zip]," ","")
--
Steve Schapel, Microsoft Access MVP
My Access 2000 db contains [sites].[zip] which is a text field
containg zip codes, in the format of country code and zip code, i.e
DE40 44 4 or 44 0 44 for a German address. I would like remove the
spaces from [sites].[zip]
I have already received advice removing alpha, or nonnumeric,
characters.
Paul
