RE: [AccessDevelopers] Left string question

 

You can use the Replace() function to replace the "&" with "". You might want to replace " &" with " ,".
 
Duane Hookom
MS Access MVP
 

---

To: AccessDevelopers@yahoogroups.com
From: luvmymelody@yahoo.com
Date: Thu, 1 Dec 2011 21:34:06 +0000
Subject: [AccessDevelopers] Left string question

 

Hello all

I have a field that has a name field with the examples Below.

I would like to get rid of the & in the string. But I cannot find any Left to get rid of a character like an &.

Is there no way to get rid of that character?

Thank

Jim Wagner

Smith, John David & Mary Lynn
Jones, Frank & Cammie Deborah
Lee, Jim

__._,_.___

Reply to sender | Reply to group | Reply via web post | Start a New Topic

Messages in this topic (2)

Recent Activity:

• New Members 3

Visit Your Group

Please zip all files prior to uploading to Files section.

MARKETPLACE

Stay on top of your group activity without leaving the page you're on - Get the Yahoo! Toolbar now.

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use

.

__,_._,___