convert text to numeric values
in [General]
|
Prev: TEst schreib zur�ck
Next: a
From: John W. Vinson on 23 Feb 2010 11:08 On Tue, 23 Feb 2010 07:08:02 -0800, Toppo <Toppo(a)discussions.microsoft.com> wrote: >Thanks for the interest Arvin. However the module you gave a link to was to >convert numeric (currency) to text, wereas my original problem (& still is) >that I can only see being able to convert TEXT (academic years such as >2007-08) into a Numeric Value will assit me in being able to do what I want >to do - see below for full explanation. Since the text string "2008-09" ISN'T a number, you'll need to do the conversion yourself. There is no builtin Access tool that knows about academic years as a concept. You can use Val(Left([field], 4)) to get a Number value 2008 from that string, and use a query adding one to that number to get the subsequent year. -- John W. Vinson [MVP]
From: Arvin Meyer [MVP] on 24 Feb 2010 07:59 Actually: Val([FieldName]) should work for "2008-09" to get 2008, and: Val([FieldName]) +1 should get 2009. -- Arvin Meyer, MCP, MVP http://www.datastrat.com http://www.mvps.org/access http://www.accessmvp.com "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message news:17v7o5997fas1n0d8m0g8emhec4p7t28qf(a)4ax.com... > On Tue, 23 Feb 2010 07:08:02 -0800, Toppo > <Toppo(a)discussions.microsoft.com> > wrote: > >>Thanks for the interest Arvin. However the module you gave a link to was >>to >>convert numeric (currency) to text, wereas my original problem (& still >>is) >>that I can only see being able to convert TEXT (academic years such as >>2007-08) into a Numeric Value will assit me in being able to do what I >>want >>to do - see below for full explanation. > > Since the text string "2008-09" ISN'T a number, you'll need to do the > conversion yourself. There is no builtin Access tool that knows about > academic > years as a concept. > > You can use > > Val(Left([field], 4)) > > to get a Number value 2008 from that string, and use a query adding one to > that number to get the subsequent year. > -- > > John W. Vinson [MVP]
From: Toppo on 24 Feb 2010 10:42 Many thanks both Arvin and John. I'm actively working my way through this & will let you know how I get on. Thanks once again. "Arvin Meyer [MVP]" wrote: > Actually: > > Val([FieldName]) > > should work for "2008-09" > > to get 2008, and: > > Val([FieldName]) +1 > > should get 2009. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.mvps.org/access > http://www.accessmvp.com > > > "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message > news:17v7o5997fas1n0d8m0g8emhec4p7t28qf(a)4ax.com... > > On Tue, 23 Feb 2010 07:08:02 -0800, Toppo > > <Toppo(a)discussions.microsoft.com> > > wrote: > > > >>Thanks for the interest Arvin. However the module you gave a link to was > >>to > >>convert numeric (currency) to text, wereas my original problem (& still > >>is) > >>that I can only see being able to convert TEXT (academic years such as > >>2007-08) into a Numeric Value will assit me in being able to do what I > >>want > >>to do - see below for full explanation. > > > > Since the text string "2008-09" ISN'T a number, you'll need to do the > > conversion yourself. There is no builtin Access tool that knows about > > academic > > years as a concept. > > > > You can use > > > > Val(Left([field], 4)) > > > > to get a Number value 2008 from that string, and use a query adding one to > > that number to get the subsequent year. > > -- > > > > John W. Vinson [MVP] > > > . >
From: De Jager on 13 Mar 2010 13:00
"Arvin Meyer [MVP]" <arvinm(a)mvps.invalid> wrote in message news:e8YDFGVtKHA.5940(a)TK2MSFTNGP02.phx.gbl... > Actually: > > Val([FieldName]) > > should work for "2008-09" > > to get 2008, and: > > Val([FieldName]) +1 > > should get 2009. > -- > Arvin Meyer, MCP, MVP > http://www.datastrat.com > http://www.mvps.org/access > http://www.accessmvp.com > > > "John W. Vinson" <jvinson(a)STOP_SPAM.WysardOfInfo.com> wrote in message > news:17v7o5997fas1n0d8m0g8emhec4p7t28qf(a)4ax.com... >> On Tue, 23 Feb 2010 07:08:02 -0800, Toppo >> <Toppo(a)discussions.microsoft.com> >> wrote: >> >>>Thanks for the interest Arvin. However the module you gave a link to was >>>to >>>convert numeric (currency) to text, wereas my original problem (& still >>>is) >>>that I can only see being able to convert TEXT (academic years such as >>>2007-08) into a Numeric Value will assit me in being able to do what I >>>want >>>to do - see below for full explanation. >> >> Since the text string "2008-09" ISN'T a number, you'll need to do the >> conversion yourself. There is no builtin Access tool that knows about >> academic >> years as a concept. >> >> You can use >> >> Val(Left([field], 4)) >> >> to get a Number value 2008 from that string, and use a query adding one >> to >> that number to get the subsequent year. >> -- >> >> John W. Vinson [MVP] > > |