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

 

I had missed the fact that Robin's first post used an "=" while the second correctly used ":".  I was looking at the expression and couldn't find a difference in the posts.

Duane Hookom, MVP
MS Access

---

To: MS_Access_Professionals@yahoogroups.com
From: MS_Access_Professionals@yahoogroups.com
Date: Mon, 13 Jun 2016 16:12:19 +1000
Subject: Re: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS




Thanks Crystal

Yes all is well, The error was mine!  Again!!!

Cheers,

Robin

At 13/06/2016 01:41 PM, you wrote:

 

Hi Robin,

so you're good?

if not, please check your field name in the table design ... and ensure there is no field called Initial in the source of the query

thanks

warm regards,
crystal

~ have an awesome day ~

On 6/12/2016 7:07 PM, Robin Chapple robinski@westnet.com.au [MS_Access_Professionals] wrote:

The "OOOPS" message confirmed that I had corrected my mistake. It showed the original message and the corrected version.

Thanks for the support.

Regards,

Robin Chapple

At 13/06/2016 01:54 AM, you wrote:

 

What do you mean by "failed miserably"?

Based on your values, your expression should have worked. I think we are missing part of the puzzle.

Duane Hookom, MVP
MS Access

Get Outlook for iOS




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



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: Duane Hookom <duanehookom@hotmail.com>

---

Reply via web post

•

Reply to sender

•

Reply to group

•

Start a New Topic

•

Messages in this topic (9)

---

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

.

__,_._,___