| re: Filtering Non Numberic Results
"Tarvos{k}" <tarvos@chartermi.net> wrote in
news:04A1e.17811$Yc2.16520@fe04.lga:
[color=blue]
> 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
>[/color]
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.
| 
