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

A criterion of

LIKE "*#*"

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

John W. Vinson [MVP]