UtterAccess.com
X   Site Message
(Message will auto close in 2 seconds)

Welcome to UtterAccess! Please ( Login   or   Register )

Custom Search
> Standardizing Street Addresses, Access 2010    
 
   
argeedblu
post Jul 24 2014, 11:07 AM
Post#1


Remembered
Posts: 14,079
Joined: 26-September 02
From: Sudbury, Ontario, Canada


In my current project, we want to use street address field(s) to group people for follow up contact. The assumption is that people who share a common street address may be members of the same household. Initial information comes from a 3rd party and is not in any particular order. Two people who are potentially related by street address my by many entries apart in the source data. For this to work, it is essential to test potential matches at data entry time. I'm looking for thoughts on possible strategies for testing for potential relationships to assist with maintaining a many-many relationship between people and street addresses.
otential source data might look like this:
Attached File  civic_addresses.png ( 53.28K )Number of downloads: 10

Any and all thoughts most welcome.
Glenn
Go to the top of the page
 

Posts in this topic
- argeedblu   Standardizing Street Addresses   Jul 24 2014, 11:07 AM
- - pere_de_chipstick   Hi Glenn checked if specific address spaces match...   Jul 24 2014, 12:09 PM
- - RAZMaddaz   PMFJI, Glenn, Take a look at the Query I created a...   Jul 24 2014, 12:53 PM
- - cheekybuddha   One option is to have a list of abbreviations/full...   Jul 24 2014, 01:00 PM
- - nvogel   Hi Glenn, you may be aware that there are some sof...   Jul 24 2014, 03:40 PM
- - orange999   Glenn, This addressing guide from Canada Post show...   Jul 24 2014, 04:29 PM
- - xordevoreaux   I have the same issue - attempting to identify who...   Jul 25 2014, 06:49 AM
- - argeedblu   My apologies if this seems to be somewhat of an om...   Jul 26 2014, 08:14 AM
- - xordevoreaux   1. Feel free to borrow the naming convention, I...   Jul 28 2014, 06:48 AM
- - Jeff B.   <Glenn> OPO (just one person's opinion) ...   Jul 28 2014, 06:54 AM
- - argeedblu   Thanks xordev.   Jul 28 2014, 07:51 AM
- - orange999   I agree with Jeff B here. This is not likely to be...   Jul 28 2014, 08:03 AM
- - argeedblu   Thanks Orange, I am composing a reply to Jeff at t...   Jul 28 2014, 08:08 AM
- - argeedblu   Thanks Jeff, it certainly seems that way. long tho...   Jul 28 2014, 08:21 AM
- - dmhzx   This is all done with a hint of tongue in cheek...   Jul 28 2014, 08:28 AM
- - argeedblu   dmhz, Thanks for the thought. However Canadian pos...   Jul 28 2014, 08:36 AM
- - dmhzx   For goodness sake Glenn Don't ever post someth...   Jul 28 2014, 09:03 AM
- - ZapDude   I have an automated street address parsing system ...   Aug 4 2014, 12:46 PM
- - argeedblu   Zapdude, Thank you very much for your insight. Sin...   Aug 4 2014, 02:39 PM
- - orange999   Zapdude, Just to agree 100% with Glenn, your tutor...   Aug 4 2014, 02:53 PM
- - ZapDude   I apologize for not following up with this project...   May 15 2018, 12:22 PM



Custom Search


RSSSearch   Top   Lo-Fi    20th November 2019 - 05:14 AM