How do I eliminate text out of this      2.5 OZ , i just want the 2.5
to show or whatever number is in there regardless of how much digits
it is. I would prefer to have this in the query field and not vba
please. Thank you.

Ryan

Hi - 

Use the Val function  in the query, instead of the whole field:

Val([myField])

Val() returns the numeric equivalent of all characters up to the first non-
numeric character in a string.  It ignores zeros.

so Val("2.5 OZ") will return 2.5 ; so does Val("2  . 5  OZ")

John


ryan.fitzpatrick3@safeway.com wrote:
>How do I eliminate text out of this      2.5 OZ , i just want the 2.5
>to show or whatever number is in there regardless of how much digits
>it is. I would prefer to have this in the query field and not vba
>please. Thank you.
>
>Ryan

-- 
Message posted via AccessMonster.com
http://www.accessmonster.com/Uwe/Forums.aspx/access-formscoding/200801/1

ryan.fitzpatrick3@safeway.com wrote:

>How do I eliminate text out of this      2.5 OZ , i just want the 2.5
>to show or whatever number is in there regardless of how much digits
>it is. I would prefer to have this in the query field and not vba
>please. 

You can use the Val function in that case.

-- 
Marsh
MVP [MS Access]