Need Help Query

[HB2]

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

Thanks for any help.

[WindAndWaves]

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" <bg******@comcast.net> wrote in message
news:Tpyqc.76609$iF6.6430711@attbi_s02...

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

Thanks for any help.

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

tHANKS!!

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Cs*******************@news.xtra.co.nz...

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" <bg******@comcast.net> wrote in message
news:Tpyqc.76609$iF6.6430711@attbi_s02...

I need to remove the first first characters of a text field in a database.
Thanks for any help.

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

[ams]

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

"HB2" <bg******@comcast.net> wrote in message
news:6Iyqc.76746$iF6.6441296@attbi_s02...

tHANKS!!

"WindAndWaves" <ac****@ngaru.com> wrote in message
news:Cs*******************@news.xtra.co.nz...

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" <bg******@comcast.net> wrote in message
news:Tpyqc.76609$iF6.6430711@attbi_s02...

I need to remove the first first characters of a text field in a database.
Thanks for any help.

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