MS ACCESS SQL, MAKE TABLE change field type

Question

Using MS ACCESS SQL, to MAKE TABLE with changing field type, which coding should be used? eg. a Character type field with data '0056.80' is wanted to be converted to numeric type 56.8 Help!!

Answer 1

Start with a SELECT query where you transform your character field to its numeric equivalent.

SELECT Val(y.char_field) AS number_field
FROM YourTable AS y;

Once you get that working, you can change the query to a "Make Table" query such as this:

SELECT Val(y.char_field) AS number_field INTO NewTable
FROM YourTable AS y;