zip code range issue

[Guest]

Hello,

I was provided a table (XXXXZipCodeSvc) from another party that lists zip
range low and zip range high and a code for each range.

example

zip range low zip range high code
01460 01460 100
01718 01720 100
01730 01731 100

I have another table (ImportTable) that I created that lists orgin zip codes
and I want to query that origin zip table against the zip range table and
return the code. The query I created using the join works fine for the one
zip range as shown on the first row but not for the other two.

Suggestions? I wish I spent more time in Access as part of my job so these
things would come easier to me but you know how it is.

thanks

Michael

 

[Guest]

Oh, also, there are both US zip codes and Canadian Postal codes in the table
provided by the third party. I am assuming I will need to split that
original table into 2 because of the data type difference?

thanks

 

[John W. Vinson]

The query I created using the join works fine for the one
zip range as shown on the first row but not for the other two.

If you'ld like help fixing the query, please post the SQL of the query. Right
now you're leaving us in the dark.

John W. Vinson [MVP]