table/field

[buyukkemal]

I have update excel file to access table. one of type of table field is text in access table. (because excel field was text). but there is numeric values in text field like -2,345.67 . inorder to sum or to make another mathematichs operrations, I have to turn field type to numeric type. but if I change field type, all numeric data in field does broken. how can I solve that problem.

waiting your help I m sending my best regards.

 

[spoole]

Are their purely numbers in this field, no special characters or letters?

If so you can create a query that will convert the numbers into numeric, look at Val(String) method and create a new table with all the fields plus the new one (Val string thing).

 

[buyukkemal]

Thanks very much, field is including only like that (-2,345.67) , but those doesn't number. all that are text. I will look at Val(String).