Prev: DELETE column in TABLE
Next: Query filtering by Aggregate
From: Michelle W. on 17 Mar 2010 11:24
How do I test a text field for numeric data? How do I test a text field for
alpha data?
From: vanderghast on 17 Mar 2010 11:46
? IsNumeric("33.6"), IsNumeric("44A"), val("44a")
True False 44


So, IsNumeric can do, if the whole field has to be numerical, else, val( )
can extract the first number seen.


Not IsNumeric is an "alpha" field, or you mean "alpha' is only a text that
will NOT contain any digit? if so, the NOT LIKE "*[0-9]*" could do.



Vanderghast, Access MVP

"Michelle W." <MichelleW(a)discussions.microsoft.com> wrote in message
news:E8874F81-C199-4774-BD45-93CC36AD1741(a)microsoft.com...
> How do I test a text field for numeric data? How do I test a text field
> for
> alpha data?

From: Marshall Barton on 17 Mar 2010 12:24
Michelle W. wrote:

>How do I test a text field for numeric data? How do I test a text field for
>alpha data?


Numeric is kind of vague. If you mean all decimal digits.
you can use this kind of comparison:

Not ([text field] Like "*[!0-9]*")

similarly for all alphabetic characters:

Not ([text field] Like "*[!a-z]*")

--
Marsh
MVP [MS Access]
 | 
Pages: 1
Prev: DELETE column in TABLE
Next: Query filtering by Aggregate