Re: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS

 

Duane,

A sample is below.

Regards,

Robin



Wilma
Vickie
Val
Val
Trisha
Trial Stay
Thelma
Susan
Susan
Shirley
Shirley
Shirley
Shirley
Shirley
Sarah
Rosie
Rosemay
Rita
Rene
Phillipa
Peggy
Peg
Pearl
Pauline
Patricia
Patricia
Pat
Pat
Pat
Pam
Norma
Norma
Norma
Nancy
Nancy
Nancy
Nadia
Mona
Molly
Millie
Michele
McDonald
Maureen
Maureen
Mary
Mary
Mary
Marie
Margo
Margery
Margaret
Margaret
Marg
Luciana



At 12/06/2016 04:39 PM, you wrote:

 

Robin,
Could you provide a variety of actual first name values?

Duane Hookom, MVP
MS Access

Get Outlook for iOS




On Sun, Jun 12, 2016 at 3:38 AM +0200, "Robin Chapple robinski@westnet.com.au [MS_Access_Professionals]" < MS_Access_Professionals@yahoogroups.com> wrote:



OOOPS!


Initial:Left([mFirstName],1)

That's better.

Cheers,

Robin



At 12/06/2016 11:13 AM, you wrote:

 


I need to extract the initial from the first names in a member directory.

I tried using this in a query - Initial=Left([mFirstName],1) and
failed miserably.

What have I missed?

Many thanks,

Robin Chapple

__._,_.___

---

Posted by: Robin Chapple <robinski@westnet.com.au>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (4)

---

Have you tried the highest rated email app?

With 4.5 stars in iTunes, the Yahoo Mail app is the highest rated email app on the market. What are you waiting for? Now you can access all your inboxes (Gmail, Outlook, AOL and more) in one place. Never delete an email again with 1000GB of free cloud storage.

---

Visit Your Group

• Privacy • Unsubscribe • Terms of Use

.

__,_._,___