Make Table Query to Exclude Particular Zip Code

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

PCGrammy - 04 Nov 2005 17:16 GMT

Zip Code field uses 00000\-9999;0;_ as the input mask. What code would I
need to type in the criteria field to return a table which excludes all
records within a five-digit +4-digit zip code? By using the <> with a
five-digit zip code only, it works correctly; however, the make table query
still returns all records with the 5 + 4-digit zip code.
Any help would be appreciated.

Signature

PCGrammy

Reply to this Message

KARL DEWEY - 04 Nov 2005 18:17 GMT

You are probably typing the criteria entry like this --- 23456-0123 but you
need to omit the dash as it is not stored in the field.

> Zip Code field uses 00000\-9999;0;_ as the input mask. What code would I
> need to type in the criteria field to return a table which excludes all
> records within a five-digit +4-digit zip code? By using the <> with a
> five-digit zip code only, it works correctly; however, the make table query
> still returns all records with the 5 + 4-digit zip code.
> Any help would be appreciated.

Reply to this Message

[MVP] S.Clark - 04 Nov 2005 18:43 GMT

Select * from tablename where left$(zipcode,5) <> "12345"

Signature

Steve Clark, Access MVP
http://www.fmsinc.com/consulting

> Zip Code field uses 00000\-9999;0;_ as the input mask. What code would I
> need to type in the criteria field to return a table which excludes all
[quoted text clipped - 3 lines]
> still returns all records with the 5 + 4-digit zip code.
> Any help would be appreciated.

Reply to this Message