text to numeric fields

[shark1966]

The data I am pulling from a .dbf has some fileds text that I need numeric.
How do I convert these fields so I can run numeric functions against them?

 

[Ofer]

Try

Cdbl([FieldName])

 

[Brendan Reynolds]

Here's a link to the on-line help topic on 'Type Conversion Functions' ...

http://msdn.microsoft.com/library/d...y/en-us/vbenlr98/html/vagrptypeconversion.asp