Re: Wonderful!
- From: "Dirk Goldgar" <dg@xxxxxxxxxxxxxxxxxxxxxxxxxxxxxx>
- Date: Tue, 18 Nov 2008 23:11:55 -0500
"Southern at Heart" <SouthernatHeart@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:2966F3E5-6A9B-43FF-AA5F-D6ADA9BDB347@xxxxxxxxxxxxxxxx
That was great! I tweaked it with a couple (( and a ;
and it works perfect!
Did you do that because you found it didn't work as originally posted, or just because you thought you should? because I think it ought to work the way I posted it. Note that you don't need a trailing semicolon in a SQL statement, and Access likes to add lots of unnecessary parentheses when you build queries in the design grid.
Another similar question:
Could you alter this a little so that it works the same way only instead of
removing the trailing returns from the end of the field/fields, it removes
the two characters
^b (or ^B) from any part of the field. Baxsically, replace ^b or ^B with
nothing.
Literally "^b" and "^B"?
Removing strings from any part of a field is simpler than removing them from just the end of the field, as you can just use the Replace function, and don't need to loop until they're all gone.
--
Dirk Goldgar, MS Access MVP
www.datagnostics.com
(please reply to the newsgroup)
.
- Follow-Ups:
- Re: Wonderful!
- From: Southern at Heart
- Re: Wonderful!
- References:
- Wonderful!
- From: Southern at Heart
- Wonderful!
- Prev by Date: PS to this last question
- Next by Date: how can i search two unrelated tables at the same time Access 200
- Previous by thread: Re: PS to this last question
- Next by thread: Re: Wonderful!
- Index(es):
Relevant Pages
|
