Get rid of first 2 characters.

  • Thread starter Thread starter Dazed And Confused
  • Start date Start date
D

Dazed And Confused

I have a text field in a query called short_description that produces
the names of the following: C-Math, C-English, C-Geography, etc...
How can I get rid of the "C-" so that it just shows Math, English,
Geography, etc?
Any help would be much appreciated.
Thanks,
 
Use the Mid function to grab all the characters from character 3 on.

Field: FixDescription: MID(Short_Description,3)

John Spencer
Access MVP 2002-2005, 2007-2009
The Hilltop Institute
University of Maryland Baltimore County
 
Back
Top