Copy properties one field to another field with different field types

turguttosun

I have two different field with different properties as can be shown from photo. 

I need to copy one field  properties to another becaure there are more than 2000 rows.

When I try it gives error "The value is you entered is out of range or is not a whole number"

First field type is double second one is float. Thanks for answer.

 

 

DanPatterson

If column2 needs to be long, then you will lose the decimals when the copy is made.

And you would have to do

int(column1) 

to do the rounding.  If it was float, then the decimal values would copy over unless there was an overflow caused by the reduction in field type.

Did you try any of the suggestions?