quick! convert text field to numeric (WITH negatives)

  • Thread starter Thread starter R
  • Start date Start date
R

R

I need quick help - can't find it! String function, usable in query, to
convert a text field to a numeric field (one that can be negative).

HELP!
 
Val(String) should do what you want.

also, take a look at CDbl, CLng, CInt, CSng, CCur
 
Ugh, OK, here's the problem. Nice of me to notice earlier ...

The field has leading zeros... so I'm wanting to display "-9.34" when the
field actually has "0000-9.34".

And of course, the number of leading zeros varies, and not all numbers are
either positive or negative.

Thoughts?

Thanks, John.
 
Back
Top