If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

Re: Convert text number to a number in a MS Access.

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

Re: Convert text number to a number in a MS Access.

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

Re: Convert text number to a number in a MS Access.

"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.