How do i create a search result of stores available base on state then zipcode input by customers?

i got the state query to work. now how do i compare the input zipcode to the database so that only the closest store to the zipcode entered is display?

thanks

That depends how your database is structured. You need to have some sort of spatial index that tells you which zip codes are close to other zip codes.

I dont know, maybe you can just use the first 3-4 digits of a zip code, but that probably wont be very accurate when dealing with areas that cross state or county lines.

What you essentially doing is 'geocoding' which is a sophisticated way of computer mapping of an address and you may well need some specific GIS software for this task, such as that made by ESRI (WWW.ESRI.COM/, they make a product called ArcIMS that can be used to build customized webpages with any web based language (including ASP), but its not cheap.

thanks. i am using MS Access; does it allow spatial index?

Have you talked to the US Postal Service about this yet? Often times, the posties have XML-based tools for things like this that you can use for free.