Converting Text To Columns

[gameemaster]

I have two tables. I import one (1) table that has a column as a Number (Column 1), and it stays a number. I have another table, that I import a column as Text (Column 2), that's because it has characters attached to it like 144147R or 134991A.



I am able to remove alphas on the text column import to remove the letters. Now I am trying to run an inner join and a left join on those two columns. I have used the Fortmat(), Val(), Int(), CDbl() functions, trying to convert the removed alphas text column (Column 2), which would technically be Column 3, since I had to use a module to remove the alphas.

I've tried all those functions to convert a text column to a number after I have removed alphas, removing alphas requires me to create a 3rd column (Column 3), so I want to inner join and left-join column 1 and column 3, but I cannot get column 3 formatted as a number!

Please Help!

[June7]

Column 3 is a number type field in table? You have populated it with modified value? This works fine for me. Value is saved to number type field and therefore is a number.

Also no problem using Val() function to convert value in query and then joining the query to table.