access2002

  • Thread starter Thread starter Dawn
  • Start date Start date
D

Dawn

Help I am trying to do a query and I need to omit two
beginning letters of a field. Please help I am not
getting anywhere. P.S. Thank you if you can.
Dawn I tried to use Not Like "*", <> the letter. help
 
-----Original Message-----
Help I am trying to do a query and I need to omit two
beginning letters of a field. Please help I am not
getting anywhere. P.S. Thank you if you can.
Dawn I tried to use Not Like "*", <> the letter. help
.
Click to expand...
This will do it for you.

Expr1: Mid([ConditionType],3,20)

Exp1 is a bogus name for a field in a query
Mid is the Mid string function
ConditionType is the field that had the information in it
to be parsed.
3 is the 1st character to be displayed
20 is the amount of characters to be displayed

This code will always display the field in question
(ConditionType) beginning with the 3rd letter and
proceeding for 20 letters.

Enjoy!
 
Back
Top