Need Help Query

[HB2]

I need to remove the first first characters of a text field in a database.

Thanks for any help.

[WindAndWaves]

Re: Need Help Query

the function to use is right([field], Len([field])-2)

field = your fieldname
Len = number of characters in string
right = see help
2 = the number of characters you would like to chop-off

Let me know if this enough

Nicolaas

"HB2" <bgreer24@comca st.net> wrote in message
news:Tpyqc.7660 9$iF6.6430711@a ttbi_s02...[color=blue]
> I need to remove the first first characters of a text field in a database.
>
> Thanks for any help.
>
>[/color]


---
Please immediately let us know (by phone or return email) if (a) this email
contains a virus
(b) you are not the intended recipient
(c) you consider this email to be spam.
We have done our utmost to make sure that
none of the above are applicable. THANK YOU
Checked by AVG anti-virus system (http://www.grisoft.com).
Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004

[HB2]

Re: Need Help Query

tHANKS!!

"WindAndWav es" <access@ngaru.c om> wrote in message
news:Csyqc.6990 $XI4.254371@new s.xtra.co.nz...[color=blue]
> the function to use is right([field], Len([field])-2)
>
> field = your fieldname
> Len = number of characters in string
> right = see help
> 2 = the number of characters you would like to chop-off
>
> Let me know if this enough
>
> Nicolaas
>
> "HB2" <bgreer24@comca st.net> wrote in message
> news:Tpyqc.7660 9$iF6.6430711@a ttbi_s02...[color=green]
> > I need to remove the first first characters of a text field in a[/color][/color]
database.[color=blue][color=green]
> >
> > Thanks for any help.
> >
> >[/color]
>
>
> ---
> Please immediately let us know (by phone or return email) if (a) this[/color]
email[color=blue]
> contains a virus
> (b) you are not the intended recipient
> (c) you consider this email to be spam.
> We have done our utmost to make sure that
> none of the above are applicable. THANK YOU
> Checked by AVG anti-virus system (http://www.grisoft.com).
> Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
>
>[/color]

[ams]

Re: Need Help Query

How cool is that. I was looking for something similar.
ams



"HB2" <bgreer24@comca st.net> wrote in message
news:6Iyqc.7674 6$iF6.6441296@a ttbi_s02...[color=blue]
> tHANKS!!
>
> "WindAndWav es" <access@ngaru.c om> wrote in message
> news:Csyqc.6990 $XI4.254371@new s.xtra.co.nz...[color=green]
> > the function to use is right([field], Len([field])-2)
> >
> > field = your fieldname
> > Len = number of characters in string
> > right = see help
> > 2 = the number of characters you would like to chop-off
> >
> > Let me know if this enough
> >
> > Nicolaas
> >
> > "HB2" <bgreer24@comca st.net> wrote in message
> > news:Tpyqc.7660 9$iF6.6430711@a ttbi_s02...[color=darkred]
> > > I need to remove the first first characters of a text field in a[/color][/color]
> database.[color=green][color=darkred]
> > >
> > > Thanks for any help.
> > >
> > >[/color]
> >
> >
> > ---
> > Please immediately let us know (by phone or return email) if (a) this[/color]
> email[color=green]
> > contains a virus
> > (b) you are not the intended recipient
> > (c) you consider this email to be spam.
> > We have done our utmost to make sure that
> > none of the above are applicable. THANK YOU
> > Checked by AVG anti-virus system (http://www.grisoft.com).
> > Version: 6.0.687 / Virus Database: 448 - Release Date: 16/05/2004
> >
> >[/color]
>
>[/color]