access+vba+courses+london - Geographic locations and logistics

Resolved · Low Priority · Version Standard

Mon 18 Dec 2006, 13:17 Delegate Mark said...

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)?

Tue 19 Dec 2006, 09:38 Edited on Tue 19 Dec 2006, 14:26 Trainer David said...

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

Wed 20 Dec 2006, 19:52 Delegate Mark said...