[AccessD] Australia - find nearest location

Thanks Michael - I think I need to learn about the way / rules that postcodes are allocated in my region - that way I may be able to create some sort of process. Just thought someone may have looked into that before.

Basically what I need to know is whether proximity in number = proximity in distance - I am guessing that it won't always be the case...

Kath


----- Original Message ----- 
  From: Michael Maddison 
  To: Access Developers discussion and problem solving 
  Sent: Friday, June 10, 2005 10:48 AM
  Subject: RE: [AccessD] Australia - find nearest location


  Never tried myself, but the discussions here recently on MapPoint might
  lead the way.

  cheers

  Michael M

  Hi all - Just wondering whether there happens to be anyone on list who
  may already have done this - 

  I'm writing a new system for a training company and they want add a
  geographic search capability - ie. they would like to enter a suburb or
  postcode and the system displays will show the courses which run closest
  to them geographically.

  Any tips? Or if anyone has done this at all - can you tell me what your
  approach was?

  Thanks - rgds

  ______________________________________________
  Kath Pelletti
  Software Design & Solutions Pty Ltd.
  Ph: 9505-6714
  Fax: 9505-6430
  KP at SDSOnline.net
  --
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com
  -- 
  AccessD mailing list
  AccessD at databaseadvisors.com
  http://databaseadvisors.com/mailman/listinfo/accessd
  Website: http://www.databaseadvisors.com