Thanks in advance
I have an access database that is used for scheduling audits. What i would like to do is get the driving time from the auditors house to the location of the audit.
I have a query returning available auditors and their address[qry_USEABLE_REPS_forSTATE]
I also have a query returning the address for the PDN(primary dealer) that was selected [qry_dlr#-and-drive-time].
What i want to do is calculate the driving time between the two locations
When i run [qry_USEABLE_REPS_forSTATE] i will get this:
Rep Address City State Zip
rep1 247 dayton rd dawson pa 15428
rep2 287 rough drive cranberry pa 16066
rep3 124 juniper drive butler pa 16066
When i run [qry_dlr#-and-drive-time] i will get.
PDN Dealer Name Address city state zip
12345 John howard 216 dear st erie pa 16507
What i want to do is run a loop that looks at the first rep in [qry_useable_reps_forstate] and calculates driving distance to the dealer location in [qry_dlr#-and-drive-time]
After it looks at the first rep it returns a drivetime for rep1
then goes to rep2 and so on
I want to return the results to the form so that i can see how long it takes each rep to get to the dealer
Is this possible?