Changing field data type but keeping data

[Kozbot]

Hello

I have a field in a table that is comprised of mostly numerical data but some records are text.

I want to convert this field to numerical only and make a new field to put the textual data in.

However converting the field will delete the textual data. What is the easiest way to convert the field but save the textual data AND append the textual data to the SAME record that they were in originally in the new field?

Thank you

 

[plog]

Let's assume your existing field is called 'F'

1: Rename 'F' to 'tmp'.
2: Create a new numeric field called 'F'.
3: Create an Update Query to populate values into 'F' from 'tmp'.
4: Create an Update Query to place null values in 'tmp' where 'tmp' is numeric.


And as always, step 0 is to make a backup copy of your table before changing any data.

 

[Kozbot]

DONE

spanks you very much