98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Access Training and help » access+vba+courses+london - Geographic locations and logistics
access+vba+courses+london - Geographic locations and logistics
Resolved · Low Priority · Version Standard
Mark has attended:
Access Intermediate course
Access Advanced course
Access VBA course
Geographic locations and logistics
I have set up a database with records for each site visit (including address)and have a field for region to help operations staff group sites. However I am on my third revision of defining regions, and sites on borders between regions may not get placed in the best 'bundle' so started to think about another field to indicate next nearest region.
Is there an add on facility to effectively give the access database a lookup, or alternatively a purpose made logistics programme which will somehow take in data from our database, and preferably not too expensive (hundreds preferred to thousands)?
RE: Geographic locations and logistics
Hi Mark
I believe you are after an application to add on to your database so that it will perform an address lookup and find the next closest site. If this is what you are looking for, then you basically want a system like Argos or B&Q on their website to find the closest store to a given address. I do not personally know how much a system such as this costs, but I do know that a company called QAS specialise in this sort of program.
Thier web address is : www.qas.co.uk
Hope this helps
David
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Access tip:How To Display An '&' In A Label In A FormTo have your label display a sentence with an &(ampersand) in it, like Fox & Hound simply type it as: |