I need to remove a dash from a number string.

[catguy]

New to access and have a problem.
I have 2 tables of data that I would like to use in a query. The common field in both tables is named "Material" and will be used for a join.
I believe though, I may have a format issue with the data.


In table "QM15_Notifications", the Material is a text data type and consists of all numbers (i.e. 3235465) and in the other table "tblQNET_IQA", the Material is also a text data type and consists of numbers seperated with a dash (i.e. 323-5465).
I have many other tables in this db that do not have the dash in the data for "Material", so how do I remove the dash from tblQNET_IQA?

[pbaldy]

You can use the Replace() function to get rid of the dash, either for display or in an update query to change the actual data.

[catguy]

Thanks... worked like a charm.

[pbaldy]

No problem, and welcome to the site by the way.