I feel terrible for asking so many questions, but I just can get this figured out and have watched every single video and read sooooo many links related to what I’m trying to do and distance, latlong, addresses and locations and I’m STILL stuck and seriously don’t want to give up…
I’m pretty sure what I’m trying to do IS doable, I just can’t get it to work.
Not sure if I need more columns to help it better calculate or what.
I have an “itinerary” table
I want to be able to enter a “coming from” address and then have the “hidden from” column reference(?) the address in “coming from” and translate it to the approx latlong.
Then I have a “going to” column and a “hidden going” column, that I want to basically do the same, but with a different address.
Then I want to be able to calculate the distance between the 2 as well as calculate the travel time that would take.
- I think I know how to do this part, at least the distance part and I’ll have to figure out some math to calculate the time…somehow, if that possible.
But I’m stuck because I can’t figure out how the get the latlong columns to pick up on the addresses entered and then calculate the latlong without physically moving the latlong indicator or knowing the latlong of the address.
If anyone understands what I’m trying to do and could offer some advice, it would be GREATLY appreciated!
Thank you so much in advance.