Strip out hyphens from column data? ex.2434-2343-4324

[Mitchell_Collen via AccessMonster.com]

Hi,
How do you strip out the hyphens in the following numbers?

23434-200234-234
23423-324244-234
23443-234313-343

I want the all values in the column to contain no hyphens, do you know what
to do? Thanks in advance. Misty

 

[fredg]

Hi,
How do you strip out the hyphens in the following numbers?

23434-200234-234
23423-324244-234
23443-234313-343

I want the all values in the column to contain no hyphens, do you know what
to do? Thanks in advance. Misty

On a form?

=Replace([FieldName],"-","")

 

[Mitchell_Collen via AccessMonster.com]

no, sorry I didn't specify that its a query. i see now that i posted in the
forms group. sorry about that too. do you think that I can use that same
logic in a query?

 

[Klatuu]

Yes, but it has to be a calculated field

SELECT Replace([FieldName],"-","") As AnotherName

Or in the Query Builder

AnotherName: Replace([FieldName],"-","")

 

[Douglas J. Steele]

Sure. Just use the Replace function to create a calculated field.

 

[Mitchell_Collen via AccessMonster.com]

Thanks so much! It worked great! -Misty