Data Handling

[Jack Warring]

I'm sure many will know the answer to this question. I need to know how to move a text field value to a numeric field (assuming the text field only contains numbers).

When I just try to assign numeric field = text field, I get incompatible data type error message.

Thanks,
Jack

 

[laa]

numeric field = INTEGER(text field).

 

[Crittar]

OR numeric field = DECIMAL(character field) depending on the format of the variable you want to store it in.