高级邮政编码匹配

问题描述

我正在为一家酒店连锁店准备一个Access数据库，这家酒店遍布英国各地的几家酒店

。所需的功能如下：


1.客户想知道距离特定地点最近的酒店。


2。客户端邮政编码中的db用户密钥和系统返回

最接近他们的三家酒店，格式类似如下：


距离表格邮政编码酒店名称地点电话

5.5英里皇家布里斯托尔

01555 5551

123英里丽晶酒店0207

557 5555

125英里伦敦广场

0207 667 4444


是否有人知道将使用第三方工具做这个？我需要的全部

是可以占用所有酒店邮政编码（约30个）和

计算每个人与用户输入的邮政编码的距离。我可以做剩下的
。


谢谢，


Paul

解决方案

将选择权交给GoogleMaps在

那个地区的酒店会不会更容易？

感谢您的回复。


这不行不通; Access数据库存储了这家连锁酒店拥有的30家
酒店的列表。

我正在努力寻找这些酒店中最好的三场比赛。

用户输入邮政编码。


Paul

I am planning an Access database for a Hotel chain with several hotels
all over the UK. The required functionality is as follows:

1. A client wants to know the nearest hotel/s to a specific location.

2. The db user keys in the client''s postcode and the system returns
the three hotels nearest to them in a format similar to the following:

Distance form Postcode Hotel Name Location Tel
5.5 miles The Royal Bristol
01555 5551
123 miles The Regent London 0207
557 5555
125 miles The Plaza London
0207 667 4444

Does any one know of a third party tool that will do this? All I need
is the bit that can take all of the Hotel postcodes (about 30) and
calculate the distance of each of them to the user entered postcode. I
can do the rest.

Thanks,

Paul

解决方案

Wouldn''t it be easier to pass the selection to GoogleMaps for hotels in
that area?

Wouldn''t it be easier to pass the selection to GoogleMaps for hotels in
that area?

Thanks for your reply.

No that would not work; the Access database stores a list of the 30
hotels owned by this hotel chain.
I am trying to find the best three matches amongst those hotels to a
user entered postcode.

Paul

这篇关于高级邮政编码匹配的文章就介绍到这了，希望我们推荐的答案对大家有所帮助，也希望大家多多支持！