Is using update query correct in this?

[MaMister]

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.

 

[Mike375]

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

 

[jwhite]

May I humbly ask, please don't post a question in multiple forums Utter Access Post).

 

[MaMister]

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?