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
|
|||
|
|||
Multiple Replacements in a query
I am using this string: Itinerary: Replace([TABLE],"-"," ")
To make my results look like this: "abc rtb ghe" rather than this "abc-rtb-ghe" I also have some slashes in the results eg. abc/def. Can I replace both the "-" and the "/" with " " in the same query? Thanks |
#2
|
|||
|
|||
Replace(Replace([TABLE],"-"," "), "/", " ")
-- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "AccessNewbie" wrote in message ... I am using this string: Itinerary: Replace([TABLE],"-"," ") To make my results look like this: "abc rtb ghe" rather than this "abc-rtb-ghe" I also have some slashes in the results eg. abc/def. Can I replace both the "-" and the "/" with " " in the same query? Thanks |
#3
|
|||
|
|||
Thanks, Doug for answering this question. Great web-site too. In case it
helps, tell your wife that your time on the access boards helps complete strangers stay sane! Regards, Dave -- "Douglas J. Steele" wrote: Replace(Replace([TABLE],"-"," "), "/", " ") -- Doug Steele, Microsoft Access MVP http://I.Am/DougSteele (no e-mails, please!) "AccessNewbie" wrote in message ... I am using this string: Itinerary: Replace([TABLE],"-"," ") To make my results look like this: "abc rtb ghe" rather than this "abc-rtb-ghe" I also have some slashes in the results eg. abc/def. Can I replace both the "-" and the "/" with " " in the same query? Thanks |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
Multiple Parameters in a Query | SLEJ | Running & Setting Up Queries | 2 | April 29th, 2005 08:43 PM |
How do you setup a Query across multiple fields? | Hyperboy | Running & Setting Up Queries | 6 | December 3rd, 2004 03:35 AM |
Big number gives error! | Sara Mellen | Running & Setting Up Queries | 8 | October 11th, 2004 02:48 AM |
Crosstab query with same VALUE in multiple columns | ChrisJ | Running & Setting Up Queries | 1 | June 20th, 2004 10:41 PM |
export 1 query multiple times to 1 excel file | WALRUSIM | Running & Setting Up Queries | 1 | June 19th, 2004 04:13 AM |