Match and near Match for Postcodes

P

Peter G

I need to be able to enter a postcode and then display the 5 nearest matching postcodes (selected from an existing table). The application is to allow my customer service staff to be able to find the nearest retailers of our product to a customer. I cant work out how to do this with a query?
 
J

JohnFol

Does your table define a location for the post code in terms of a grid
reference, or do you have a massive matrix of distances between all
postcodes?


Peter G said:
I need to be able to enter a postcode and then display the 5 nearest
Click to expand...
matching postcodes (selected from an existing table). The application is to
allow my customer service staff to be able to find the nearest retailers of
our product to a customer. I cant work out how to do this with a query?
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Loop using append query 3
Use TextBox on the main form to limit SubForm 2
You can use Google Maps with an Acess DB 10
Button on Form to find a file to use in query but not import- dbf,text,excel 1
Macro to download house prices from web 0
distance between UK postcodes for a find my nearest... 6
key postcode - retrieve suburbs 2
Looking for a better way to Parse out data from alphanumeric field 1

Top