|
| 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
February 6th, 2009, 08:14 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
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
February 6th, 2009, 08:30 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 6th, 2009, 08:35 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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
February 6th, 2009, 08:41 PM
posted to microsoft.public.access.gettingstarted
|
|||
|
|||
|
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 | |
|
|
Linear Mode
