Removing dashes from a number

[CH]

I'm trying to update a number field with numbers that have dashes in them.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with Find and Replace, but I have over 10,000 entries so I'm looking for
another way. Does anyone know what command to use in a query to be able to
take out the dashes for many different numbers? Thanks.

 

[Marshall Barton]

I'm trying to update a number field with numbers that have dashes in them.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with Find and Replace, but I have over 10,000 entries so I'm looking for
another way. Does anyone know what command to use in a query to be able to
take out the dashes for many different numbers? Thanks.

Use an Update query, BUT first Make a backup copy of the
table in case something goes wrong.

UPDATE [the table]
SET [the field] = Replace([the field], "-", "")

 

[fredg]

I'm trying to update a number field with numbers that have dashes in them.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with Find and Replace, but I have over 10,000 entries so I'm looking for
another way. Does anyone know what command to use in a query to be able to
take out the dashes for many different numbers? Thanks.

1) If the field contains dashes then it cannot be a Number field. It's
Text.

2) Permanently remove the dashes?
You need an Update query.

Update YourTable Set YourTable.FieldName = Replace([FieldName],"-","")

 

[John Spencer]

You can use the REPLACE function in an update query if your version of
Access is later than Access 2000.

UPDATE YourTable
SET YourNumberField = Replace(YourNumberField,"-","")
WHERE YOurNumberField like "*-*"

'====================================================
John Spencer
Access MVP 2002-2005, 2007-2008
The Hilltop Institute
University of Maryland Baltimore County
'====================================================

 

[John W. Vinson]

I'm trying to update a number field with numbers that have dashes in them.
For example: I'd like to change 620-46-3 to 620463. I know this can be done
with Find and Replace, but I have over 10,000 entries so I'm looking for
another way. Does anyone know what command to use in a query to be able to
take out the dashes for many different numbers? Thanks.

Well, a Number field cannot have dashes in it! What's in your table now -
datatypes? Is this numbers in a Text field, or are you trying to migrate data
from a text field containing numbers into a Number field, or are the hyphens
perhaps coming from an Input Mask?