Filtering Non Numberic Results

[Tarvos{k}]

Greetings,

I am working on importing some info from excel to Access and have run into a
problem. There are some entries in the ZipCode field that are not in
numeric form. I can't seem to find a way to filter out the non numeric one,
and would really appreciate some help. The problem is that the ones that
aren't correct are shown like this "999XX" (obviously without the quotes)
where the "9" could be any number and the "X" could be any letter.
Thanks
Tarvos

[Arno R]

If not IsNumeric(YourField) then ...

--
Hope this helps
Arno R
"Tarvos{k}" <ta****@chartermi.net> schreef in bericht news:04*******************@fe04.lga...

Greetings,

I am working on importing some info from excel to Access and have run into a
problem. There are some entries in the ZipCode field that are not in
numeric form. I can't seem to find a way to filter out the non numeric one,
and would really appreciate some help. The problem is that the ones that
aren't correct are shown like this "999XX" (obviously without the quotes)
where the "9" could be any number and the "X" could be any letter.
Thanks
Tarvos

[Bob Quintal]

"Tarvos{k}" <ta****@chartermi.net> wrote in
news:04*******************@fe04.lga:

Greetings,

I am working on importing some info from excel to Access and
have run into a problem. There are some entries in the
ZipCode field that are not in numeric form. I can't seem to
find a way to filter out the non numeric one, and would really
appreciate some help. The problem is that the ones that
aren't correct are shown like this "999XX" (obviously without
the quotes) where the "9" could be any number and the "X"
could be any letter. Thanks
Tarvos

Be reminded that Zip Codes for Great Britain, Australia and Canada
contain letters by design. The current format for US zipcodes is 5-
4, which must be saved as text. You may want to verify that these
codes are legitimate foreign codes..
Besides, unless the intent is to add, subtract, multiply or divide
the contents of a field, you should consider using a formatted tect
field. (one thing remembered from a college programming course)

--
Bob Quintal

PA is y I've altered my email address.