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 |
#11
|
|||
|
|||
Changing from capital to small letters
Thanks Tom,
It didn't work. I created an update querie and wrote it in the "Update to" line. But a window appears asking me to write what [TestString] is. Can you please tell me what I am supposed to do and where I should write it? Dimitris "Tom Lake" wrote in message ... So in my mind it's something like: Wherever a name ends with "h" change it with "c" for example. Well in Greek we have 2 possibilities for a letter so I need to change it to the other one, that is why I need this. Thank you in advance Dimitris IIf(Right([TestString], 1) = "h", Left([TestString], Len([TestString]) - 1) & "c", [TestString]) Tom Lake |
#12
|
|||
|
|||
Changing from capital to small letters
Dimitris,
Since you seem to be using the query grid, Try the following after you BACKUP your data - queries are not undoable. Field: LName Criteria: LIKE "*h" Update To: Left([Lname],Len([Lname])-1) & "c" "Dimitris" wrote in message ... Thanks Tom, It didn't work. I created an update querie and wrote it in the "Update to" line. But a window appears asking me to write what [TestString] is. Can you please tell me what I am supposed to do and where I should write it? Dimitris "Tom Lake" wrote in message ... So in my mind it's something like: Wherever a name ends with "h" change it with "c" for example. Well in Greek we have 2 possibilities for a letter so I need to change it to the other one, that is why I need this. Thank you in advance Dimitris IIf(Right([TestString], 1) = "h", Left([TestString], Len([TestString]) - 1) & "c", [TestString]) Tom Lake |
#13
|
|||
|
|||
Changing from capital to small letters
Thanks John
It worked fine. "John Spencer" wrote in message ... Dimitris, Since you seem to be using the query grid, Try the following after you BACKUP your data - queries are not undoable. Field: LName Criteria: LIKE "*h" Update To: Left([Lname],Len([Lname])-1) & "c" "Dimitris" wrote in message ... Thanks Tom, It didn't work. I created an update querie and wrote it in the "Update to" line. But a window appears asking me to write what [TestString] is. Can you please tell me what I am supposed to do and where I should write it? Dimitris "Tom Lake" wrote in message ... So in my mind it's something like: Wherever a name ends with "h" change it with "c" for example. Well in Greek we have 2 possibilities for a letter so I need to change it to the other one, that is why I need this. Thank you in advance Dimitris IIf(Right([TestString], 1) = "h", Left([TestString], Len([TestString]) - 1) & "c", [TestString]) Tom Lake |
|
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Changing danish letters æøå | LTJ | General Discussion | 0 | June 29th, 2005 02:52 PM |
how is the last name McKee spelled typed in all capital letters? | lewisusa | New Users | 5 | June 24th, 2005 06:04 PM |
Letters gets changed when copied from PDF Document | Ponnurangam | General Discussion | 14 | November 24th, 2004 03:39 PM |
excel - changing upper case letters into lower case letters | BJorg | Worksheet Functions | 4 | February 16th, 2004 08:40 AM |
Formula for all Capital Letters | Tami | Worksheet Functions | 2 | September 24th, 2003 02:48 PM |