If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Get rid of first 2 characters.
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, |
#2
|
|||
|
|||
Get rid of first 2 characters.
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 Dazed And Confused wrote: 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, |
#3
|
|||
|
|||
Get rid of first 2 characters.
Mid([short_description ], 3)
-- KARL DEWEY Build a little - Test a little "Dazed And Confused" wrote: 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, |
#4
|
|||
|
|||
Get rid of first 2 characters.
On Feb 6, 12:35*pm, KARL DEWEY
wrote: * *Mid([short_description ], 3) -- KARL DEWEY Build a little - Test a little "Dazed And Confused" wrote: 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,- Hide quoted text - - Show quoted text - Thank you all very much! Mid huh/ Well, now I know. Again, thanks. |
Thread Tools | |
Display Modes | |
|
|