|
| 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
September 8th, 2006, 10:53 PM
posted to microsoft.public.access
|
|||
|
|||
Delete text
Hi,
I have a query with result "Your name is XYZ". I would like to put command which could delete text "Your name is " and as final result I want just "XYZ". Please help. Thnx! 
|
|
#2
September 8th, 2006, 11:38 PM
posted to microsoft.public.access
|
|||
|
|||
|
Delete text
On Fri, 8 Sep 2006 23:53:16 +0200, John wrote:
Hi, I have a query with result "Your name is XYZ". I would like to put command which could delete text "Your name is " and as final result I want just "XYZ". Please help. Thnx! A calculated field JustName: Mid([fieldname], 14) will trim off the first 13 characters ("Your name is "). John W. Vinson[MVP]
|
|
#3
September 8th, 2006, 11:43 PM
posted to microsoft.public.access
|
|||
|
|||
|
Delete text
"John Vinson" wrote in message
... On Fri, 8 Sep 2006 23:53:16 +0200, John wrote: Hi, I have a query with result "Your name is XYZ". I would like to put command which could delete text "Your name is " and as final result I want just "XYZ". Please help. Thnx! A calculated field JustName: Mid([fieldname], 14) will trim off the first 13 characters ("Your name is "). John W. Vinson[MVP] Thnx, but could you be more specific? How can I add this command?
|
|
#4
September 9th, 2006, 03:04 AM
posted to microsoft.public.access
|
|||
|
|||
|
Delete text
On Sat, 9 Sep 2006 00:43:00 +0200, John wrote:
Thnx, but could you be more specific? How can I add this command? It's not a "command". It's a calculated Field in a Query. Edit your Query. In a vacant Field cell type JustName: Mid([fieldname], 14) using the name of the field which you're trying to truncate in place of "fieldname". Or, base a new query on your existing query and do the same. John W. Vinson[MVP]
|
|
#5
September 9th, 2006, 12:35 PM
posted to microsoft.public.access
|
|||
|
|||
|
Delete text
"John Vinson" wrote in message ... On Sat, 9 Sep 2006 00:43:00 +0200, John wrote: Thnx, but could you be more specific? How can I add this command? It's not a "command". It's a calculated Field in a Query. Edit your Query. In a vacant Field cell type JustName: Mid([fieldname], 14) using the name of the field which you're trying to truncate in place of "fieldname". Or, base a new query on your existing query and do the same. John W. Vinson[MVP] Thnx, that's it!!
|
| Thread Tools | |
| Display Modes | |
|
|
Linear Mode
