I hate a database with a bunch of people and their address. Their address is divided as follows:
House number, Direction (North West, South West, etc), Street Number, Street Type, zip code
What I need to do is to create a query/report where I get a list of people that I need to go see throughout the city but to shorten the process I would like to have the list ordered so it's efficient and I don't find myself going back 10 blocks to go see someone who lives next door to a person who was 2 spots higher on the list.
Here's the problem I have. The city I live is divided as a coordinates plane, streets run east-west and avenues run north-south. The problem is that avenues are classified as Courth, Road, Avenue and Place. Anything not in that category goes east-west (horizontally if you are looking at a map)
Right now I'm ordering as follows:
zip, street number, house number, street type
The problem is that some streets are getting mixed with the avenues.
Can you guys help me figure out how to effectively come up with an efficient route to visit these people?
Thanks in advance for any help and let me know if further information is needed. I have the list in Excel too but I'm much more familiar and comfortable with Access.
House number, Direction (North West, South West, etc), Street Number, Street Type, zip code
What I need to do is to create a query/report where I get a list of people that I need to go see throughout the city but to shorten the process I would like to have the list ordered so it's efficient and I don't find myself going back 10 blocks to go see someone who lives next door to a person who was 2 spots higher on the list.
Here's the problem I have. The city I live is divided as a coordinates plane, streets run east-west and avenues run north-south. The problem is that avenues are classified as Courth, Road, Avenue and Place. Anything not in that category goes east-west (horizontally if you are looking at a map)
Right now I'm ordering as follows:
zip, street number, house number, street type
The problem is that some streets are getting mixed with the avenues.
Can you guys help me figure out how to effectively come up with an efficient route to visit these people?
Thanks in advance for any help and let me know if further information is needed. I have the list in Excel too but I'm much more familiar and comfortable with Access.