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