• ** There has been a recent site upgrade. Please clear your browser cache to avoid issues. **
  • New forum feature - post voting and best solution

    Check out this thread for the details: https://www.access-programmers.co.uk/forums/threads/new-forum-feature-post-voting-and-best-answer.314134/

    This new feature looks great to me! :)

  • We now have 3 forum themes

    Go for the default (light) theme, Shades of Grey or Shades of Blue. I just added the Blue one.

    The thread about it is here: https://www.access-programmers.co.uk/forums/threads/new-forum-theme-shades-of-blue.314136/

phone number of area code (1 Viewer)

yanliang

New member
Local time
Today, 13:51
Joined
Sep 10, 2020
Messages
7
I ran into a problem where I need to find those who did not enter an area code for phone numbers.
(626)421-3459 is correct
but some are ()421-2459, are the one I need to find.
how to find those who those.
 

Gasman

Enthusiastic Amateur
Local time
Today, 17:51
Joined
Sep 21, 2011
Messages
6,845
Try Mid(field,2,1)=")"
 

namliam

The Mailman - AWF VIP
Local time
Today, 18:51
Joined
Aug 11, 2003
Messages
11,667
Like "()%"
left(field,2) = "()"
len(field) <= 10
Just to offer a few ideas
 

Pat Hartman

Super Moderator
Staff member
Local time
Today, 13:51
Joined
Feb 19, 2002
Messages
29,759
Look at your input mask. Is it set to store the separator characters or not?

To find the missing area codes, I would use the len() function.

Iif(len(yourphone)) <> 10 Then ''if the special characters are NOT stored
Iif(len(yourphone)) <>13 Then '' if the special characters are stored
 

Users who are viewing this thread

Top Bottom