Removing Space from Field in A Table

[XLML]

Hi,

I have a space in one of the fields in an Access table. The field is;

xxx- xxxxx

I would like to remove the space after the hyphen.

Any ideas?
XLML

 

[CT Witter]

Create a new query with the field as:

=LEFT([FieldName],4) &RIGHT([FieldName],5)

I'm not sure what the rest of the query looks like but here is SQL for an update query.

UPDATE Table1 SET Table1.Field1 = Left([Field1],4) & Right([Field1],5);


HTH,
CT

 

[Joe4]

Another option:

Open your table and highlight the field that needs to be fixed.
Select "Replace" from the Edit drop down menu replace a hyphen and a space ("- ") with just a hyphen ("-").
Be sure to select the "Match any part of Field" in the Match option, and click Replace All.

 

[XLML]

Thanks for the replies. I tried jmiskey's option.

It worked albeit a little slow with a side problem. After every 9,494 records of a >100K DB, it would give the message "You can't replace the current value of the field with the replacement text." I would have to click OK then restart the process.

Any ideas why?
XLML