MAPPOINT and ACCESS

[Viper]

hello all

i need some help with mappoint and access

What i have is a query that has 20 delaers names and addresses
and a query that has auditors

What i want to do is run a sql command that will put pushpins
at each of the auditors address and calculate distance to the dealer

Lets just say i only had 4 auditors and 4 dealers what i want to return
is

auditor dealer distance
1 1 25
1 2 10
1 3 50
1 4 90
2 1 80
2 2 13
2 3 22
2 4 33
3 1 36
3 2 77
3 3 88
3 4 31
4 1 54
4 2 64
4 3 55
4 4 14

This is i want returned in the form of a query to access

Is this possible or is there another way to do it?
Will it take too long to run?

I need to know the distances so i can schedule the closest auditor

Thanks

 

[John Nurick]

Hi Viper,

This is possible but can't be done just with a SQL command: you'll need
to write VBA code to automate MapPoint. The best place to start is
probably http://www.mp2kmag.com. There's also a MapPoint newsgroup
microsoft.public.mappoint