TRANSFORM txt in number...

[sal21]

I have a filed formatted text anf have a value numeric similar :1,2,558,5....
Ho to trasnsform the field in number and all value in this field.

Via query is possible?

or

is possible to set the filed in numeric and automaticcly transform text in number?


note:
Access database

[HansV]

Do you want to split the value into multiple fields, or do you want to create multiple records, with one value per record?

[sal21]

Do you want to split the value into multiple fields, or do you want to create multiple records, with one value per record?

i'm sorry, wrong explain.

"value numeric similar :1,2,558,5..."

consider this:
"value numeric in field1 txt formated similar :
1
2
558
5...

how to move the values in text field1 in field2 just formatted numeric

[HansV]

Assuming that they are all whole numbers, and that you have already created a field Field2 of type Number (Long Integer):

UPDATE MyTable SET Field2 = CLng(Field1)

[sal21]

Assuming that they are all whole numbers, and that you have already created a field Field2 of type Number (Long Integer):

UPDATE MyTable SET Field2 = CLng(Field1)

TKS!
work...