Prev: BE question
Next: Is it possible to run Access Database at a pre-set time?
From: Sam on 22 Apr 2010 12:26
What would be the best formula to use to find out if a field has
numbers in it.

example:

JOHN SMITH2
JOHN 9 SMITH
JOHN 201 SMITH

Thanks
From: fredg on 22 Apr 2010 12:47
On Thu, 22 Apr 2010 09:26:23 -0700 (PDT), Sam wrote:

> What would be the best formula to use to find out if a field has
> numbers in it.
>
> example:
>
> JOHN SMITH2
> JOHN 9 SMITH
> JOHN 201 SMITH
>
> Thanks

As the criteria on that field in a query:

Like "*[0-9]*"

--
Fred
Please respond only to this newsgroup.
I do not reply to personal e-mail
From: John W. Vinson on 22 Apr 2010 16:46
On Thu, 22 Apr 2010 09:26:23 -0700 (PDT), Sam <samcannet(a)gmail.com> wrote:

>What would be the best formula to use to find out if a field has
>numbers in it.
>
>example:
>
>JOHN SMITH2
>JOHN 9 SMITH
>JOHN 201 SMITH
>
>Thanks

A criterion of

LIKE "*#*"

will find all records containing one or more digits.
--

John W. Vinson [MVP]
 | 
Pages: 1
Prev: BE question
Next: Is it possible to run Access Database at a pre-set time?