Range

[Marke]

I have a table with 3 fields. it is as follows:

Supplier: Destination Zip: Zone:
ABC Co. 010-100 6


*What i want the user to be able to do is type in the
Supplier name, then type the first three digits of the Zip
code, and have it return the Zone. But if the Destination
Zip is 015 for example, it won't show any results. Is
there any way for the query to look to see if the 3 digits
is in between 010 and 100? Any help would be awesome.
Thanks, Marke

 

[Gary Wheeler]

Break out the Destination Zips into two fields so the
table would look like:

Supplier: DestZipStart: DestZipEnd: Zone:
ABC Co. 010 100 6

You should be able to test now and see if 015 is between
the two fields.

IE. 015 >= DestZipStart and 015 <= DestZipEnd

Hope this helps.

Gary