Convert text number to a number in a MS Access.

[James]

Does anyone know how to convert a text string that represents a number
to a number in a MS Access query. I'm using 2000 in an NT environment.

Thanks in advance for any help.

James

[Joe \Nuke Me Xemu\ Foster]

"James" <tbt102@hotmail.com> wrote in message <news:3b3d106c$1@news.devx.com>...

> Does anyone know how to convert a text string that represents a number
> to a number in a MS Access query. I'm using 2000 in an NT environment.

If you're talking about turning "500" into 500, check out Val, CDbl,
CInt, CCur, CDec, and other conversion functions. Or are you talking
about converting strings such as "five hundred" to 500?

--
Joe Foster <mailto:jfoster@ricochet.net> Got Thetans? <http://www.xenu.net/>
WARNING: I cannot be held responsible for the above They're coming to
because my cats have apparently learned to type. take me away, ha ha!

[James]

I'm talking about turning "500" into 500

I'll try the functions you listed in your posting. Thanks.


"Joe \"Nuke Me Xemu\" Foster" <joe@bftsi0.UUCP> wrote:
>"James" <tbt102@hotmail.com> wrote in message <news:3b3d106c$1@news.devx.com>...
>
>> Does anyone know how to convert a text string that represents a number
>> to a number in a MS Access query. I'm using 2000 in an NT environment.
>
>If you're talking about turning "500" into 500, check out Val, CDbl,
>CInt, CCur, CDec, and other conversion functions. Or are you talking
>about converting strings such as "five hundred" to 500?
>
>--
>Joe Foster <mailto:jfoster@ricochet.net> Got Thetans? <http://www.xenu.net/>
>WARNING: I cannot be held responsible for the above They're coming
to
>because my cats have apparently learned to type. take me away,
ha ha!
>
>

[Zack_NYC]

"James" <tbt102@hotmail.com> wrote:
>
>Does anyone know how to convert a text string that represents a number
>to a number in a MS Access query. I'm using 2000 in an NT environment.
>
>Thanks in advance for any help.
>
>James
Hi, James
Here is the answer:

This example uses the Val function to return the numbers contained in a string.

Dim MyValue
MyValue = Val("2457") ' Returns 2457.
MyValue = Val(" 2 45 7") ' Returns 2457.
MyValue = Val("24 and 57") ' Returns 24.

Let me know if you need anything else.
Best
Zack_NYC