convert text to number

[eric.l.bohon]

What i am trying to do is convert a text field to a number field in a query.

Any help

 

[Trevor G]

I would look to use the CInt or Clng functions.

Does this mean all of the entries you have in this text field are actual numbers and what is the purpose of converting them?

 

[Phildaburn]

You can also use the Val function: Val([TextFieldName])
Phil...