zip+4 query

  • Thread starter Thread starter Danielle
  • Start date Start date
D

Danielle

Hello:

I am trying to pull information from a zip code field, by
a select query in design view. The problem is I've tried
several ways to request the criteia to no avail. The data
type is text, with no format, or input mask (i.e. 00000-
0000). Can some one please explain what I can do to view
only the records with the complete zip+4 information only?

Most Gracious,

DBD
 
Since a zip+4 cannot have 0000 as the last four digits I would set the
criteria to NOT search for this.

right([zip],4)<>"0000"

Kelvin
 
Kelvin,
Unfortunately, if she has a 5 digit ZIP code, i.e. 91234,
right([zip],4)<>"0000" will return that record also.
That's not what she wanted.
She wants only 9 digit codes.

--
Fred

Please reply only to this newsgroup.
I do not reply to personal e-mail.


Kelvin Lu said:
Since a zip+4 cannot have 0000 as the last four digits I would set the
criteria to NOT search for this.

right([zip],4)<>"0000"

Kelvin

Danielle said:
Hello:

I am trying to pull information from a zip code field, by
a select query in design view. The problem is I've tried
several ways to request the criteia to no avail. The data
type is text, with no format, or input mask (i.e. 00000-
0000). Can some one please explain what I can do to view
only the records with the complete zip+4 information only?

Most Gracious,

DBD
Click to expand...
Click to expand...
 
Thank you for your response. I am getting a dialog box
asking for the zip parameter value?
-----Original Message-----
Since a zip+4 cannot have 0000 as the last four digits I would set the
criteria to NOT search for this.

right([zip],4)<>"0000"

Kelvin

Danielle said:
Hello:

I am trying to pull information from a zip code field, by
a select query in design view. The problem is I've tried
several ways to request the criteia to no avail. The data
type is text, with no format, or input mask (i.e. 00000-
0000). Can some one please explain what I can do to view
only the records with the complete zip+4 information only?

Most Gracious,

DBD
Click to expand...


.
Click to expand...
 
Thank you for your response. I am getting a dialog box
asking for the zip parameter value?
Click to expand...

Use the name of your own zipcode field.... which Kelvin did not know,
because you didn't tell him.

As noted elsethread, the 0000 criterion will NOT work correctly unless
you have every zipcode in your table filled in with a +4 portion -
0000 or otherwise.
 
Back
Top