Re: Obtain distances using zip codes?

Tech-Archive recommends: Repair Windows Errors & Optimize Windows Performance



I don't know if this newsgroup will let me attach, but here is a database
(OK, it didn't let me, but if you're interested, send me your e-mail)

with all of the zipcodes and the distances from 01923.
If you add this table to your database and as an equation you could do an
equation equal to the Absolute(Distance(A) - Distance(B))
If you ever needed to add a Zipcode, you could always Mapquest it from 01923
and add it to the database.

As far as interacting from the web, I'm not sure what's available out there,
but this seems to work for us.


"JDZTOY" <JDZTOY@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message
news:C33C1CB7-683B-4F46-A63F-5FCAE9EC0461@xxxxxxxxxxxxxxxx
I have a database with addresses and want to be able to tell access to
determine driving distance between my office address versus each employee
address zip code. Is it possible to have access utilize the internet to
perform this search?


.



Relevant Pages

  • Split Data within a column.
    ... I have a database with 146,000 records. ... contains zipcodes with and without zip+4. ... All the records with a zip4 have a hypen. ... and one column zip4 with the digits past the hypen. ...
    (microsoft.public.access.queries)
  • Zip code
    ... I have a database of zipcodes with latitude and longitude. ... method of calculating the distance between two zipcodes. ...
    (comp.lang.php)
  • Re: zip code from latitude-longitude?
    ... the Drupal project has a location module which contains a database table for zipcodes as well as data for US and Germany... ...
    (sci.geo.satellite-nav)
  • US Zipcode API for Ruby?
    ... Does anyone know of API (and database) for Ruby to provide information ... Also helpful would be zipcodes within a given ... If something doesn't exist natively for Ruby I might utilize a web service. ...
    (comp.lang.ruby)
  • Re: Setting AllowBypassKey Property
    ... As long as I open the DB with shift pressed, the app stays in Design mode. ... "Bob Bonta" wrote: ... not tested on v97 database. ... I don't see an option in this reply form to attach a file ... ...
    (microsoft.public.access.modulesdaovba)