getting rid of -

[Turi]

I have a table with a bunch of product codes (380-tt, 81-
tt, 1-f-tt, etc.). I want to get rid of all the "-"s in
the product code. How do I write a query to do this, I
know I've done it before, but I can't remember what I did.

Thanks

 

[fredg]

I have a table with a bunch of product codes (380-tt, 81-
tt, 1-f-tt, etc.). I want to get rid of all the "-"s in
the product code. How do I write a query to do this, I
know I've done it before, but I can't remember what I did.

Thanks

If you are using Access 2000 or newer you could use the Replace()
function:
Exp:Replace([FieldName],"-","")

If you are using Access 97 or older you will need to write your own
User Defined function. Post back if you need help with that.