And here I thought I was the only one around who remembers how cold and stormy it was on Day1 of the MS calendar. 8->)
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Tuesday, June 14, 2016 7:44 AM
To: MS_Access_Professionals@yahoogroups.com
Subject: Re: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS
you went to high school in the 1800's? wow, Bill ~ no wonder you know so much :)
"... help me with my math homework which she knew nothing about. Talking it out ..."
... blog?
warm regards,
crystal
~ have an awesome day ~
On 6/13/2016 1:28 PM, wrmosca@comcast.net [MS_Access_Professionals] wrote:
I'm the only one in our department who codes VBA so I'm stuck figuring out a lot of stuff on my own, but I find if I walk through the code with someone and explain what is going on I jog my brain enough to figure out the problem.
When I was in high school (yes they had high schools in the 1800's) my mom would try to help me with my math homework which she knew nothing about. Talking it out with her usually got me over what I was stuck on.
Regards,
Bill Mosca, Founder - MS_Access_Professionals
Microsoft Office Access MVP
My nothing-to-do-with-Access blog
---In MS_Access_Professionals@yahoogroups.com, <argeedblu@gmail.com> wrote :I have frequently had the same experience. My take on the phenomenon is that the limitations of email as a communication medium force us to think about and explain our concern to a much greater depth than would be the case if we weren't hoping to engage someone else in seeking a solution. More succinctly, writing the problem gets it out of our heads.
Glenn
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Monday, June 13, 2016 10:52 AM
To: 'MS_Access_Professionals@yahoogroups.com' <MS_Access_Professionals@yahoogroups.com>
Subject: RE: [MS_AccessPros] Extracting Initial From Fist Name - OOOPS
One of the many things I love about this group is that I have sometimes found my error while typing out my problem for the forum, then deleted my email, and went on to the work.
From: MS_Access_Professionals@yahoogroups.com [mailto:MS_Access_Professionals@yahoogroups.com]
Sent: Sunday, June 12, 2016 11:35 PM
To: Access Professionals Yahoo Group
Subject: 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 AccessTo: 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
This email (and all attachments) is for the sole use of the intended recipient(s) and may contain privileged and/or proprietary information. Any unauthorized review, use, disclosure or distribution is prohibited. If you are not the intended recipient, please contact the sender by reply e-mail and destroy all copies of the original message.
Posted by: "Glenn Lloyd" <argeedblu@gmail.com>
| Reply via web post | • | Reply to sender | • | Reply to group | • | Start a New Topic | • | Messages in this topic (14) |
Tidak ada komentar:
Posting Komentar