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
|
|||
|
|||
Update Query combine two functions
Is there a way to combine two functions in the Update To box for one field?
I'm trying to use Replace() to get rid of two excess strings of duplicate letters. If there is another function(I can't use code) that can get rid of a string of 3 of the same consecutive letters that would also work. Thanks in advance |
#2
|
|||
|
|||
Update Query combine two functions
On Thu, 17 Jul 2008 22:22:01 -0700, Darmahart
wrote: Is there a way to combine two functions in the Update To box for one field? I'm trying to use Replace() to get rid of two excess strings of duplicate letters. If there is another function(I can't use code) that can get rid of a string of 3 of the same consecutive letters that would also work. Thanks in advance You can pass a function call as an argument to a function call. for instance, to use Replace to remove parentheses, hyphens and blanks from a phone number - to turn (800) 555-5555 into 8005555555 - you can use Replace(Replace(Replace(Replace([Phone], "(", ""), ")", ""), "-", ""), " ", "") or, more readably, Replace( Replace( Replace( Replace( [Phone], "(", "") , ")", ""), , "-", "") , " ", "") -- John W. Vinson/MVP |
#3
|
|||
|
|||
Update Query combine two functions
That did it - thanks so much!
"John W. Vinson/MVP" wrote: On Thu, 17 Jul 2008 22:22:01 -0700, Darmahart wrote: Is there a way to combine two functions in the Update To box for one field? I'm trying to use Replace() to get rid of two excess strings of duplicate letters. If there is another function(I can't use code) that can get rid of a string of 3 of the same consecutive letters that would also work. Thanks in advance You can pass a function call as an argument to a function call. for instance, to use Replace to remove parentheses, hyphens and blanks from a phone number - to turn (800) 555-5555 into 8005555555 - you can use Replace(Replace(Replace(Replace([Phone], "(", ""), ")", ""), "-", ""), " ", "") or, more readably, Replace( Replace( Replace( Replace( [Phone], "(", "") , ")", ""), , "-", "") , " ", "") -- John W. Vinson/MVP |
Thread Tools | |
Display Modes | |
|
|