zip+4 query

[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

 

[Kelvin Lu]

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

 

[Fredg]

Take your pick:

Len([Zip])=9
or
Len([Zip])>5

 

[Fredg]

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.

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

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

 

[Danielle]

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

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

.

 

[John Vinson]

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

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.