Re: Update Query combine two functions
- From: John W. Vinson/MVP <please.reply@xxxxxxxxxxxxxxxx>
- Date: Thu, 17 Jul 2008 23:42:51 -0600
On Thu, 17 Jul 2008 22:22:01 -0700, Darmahart
<Darmahart@xxxxxxxxxxxxxxxxxxxxxxxxx> 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
.
- Follow-Ups:
- Re: Update Query combine two functions
- From: Darmahart
- Re: Update Query combine two functions
- Prev by Date: RE: Show true "repeated" entries
- Next by Date: Re: Update Query combine two functions
- Previous by thread: Re: 2 fields of different lenghts
- Next by thread: Re: Update Query combine two functions
- Index(es):
Relevant Pages
|
