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
