quick! convert text field to numeric (WITH negatives)

[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!

 

[John Spencer (MVP)]

Val(String) should do what you want.

also, take a look at CDbl, CLng, CInt, CSng, CCur

 

[R]

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.

 

[R]

Awesome! Thanks!

That does make a difference. From the debug window:

? Eval("0000-9.34")
-9.34

 

[John Spencer (MVP)]

Good one. I have to add that to my bag of tricks.

 

[Bruce M. Thompson]

Good one. I have to add that to my bag of tricks.

Just lucky enough to think of that one, John. <g>