I have a master record table which has thousands of fax numbers.

I would like to remove the spacing infront of some numbers.

I understand using the query Expr1: Replace([Fax]," ","") would help but how can I update into the master record table?

Btw, the fax field is a primary key and Yes (No Duplicates) was selected. Anything that I need to change here?

I think after removing the spacing of some numbers there should be duplicates.... Will that cause an error?

Thanks.

If you only want to remove leading spaces then to be on the safe side I would create a calculated field in a query with

NewFieldname: LTrim([FaxNumberField])

That will bring all the entries to the far left and you can see what it has done. If all OK then either update query or just copy/pase to the fax Number field

May I humbly ask, please don't post a question in multiple forums Utter Access Post (http://www.utteraccess.com/forums/showflat.php?Board=82&Number=1757517)).

Btw, I can't seem to copy the copy and paste the structure of my table. (to use append to remove duplicates) It says maximum 65000 records.

So how can I remove duplicates in Access 2007?