All,
We've missed one more possibility: misspellings. Take a look at my surname
and try to guess how many different spellings of it I've seen over the
years, then multiply by ten to be closer! How many records would I get?
Nikos
"Lynn Trapp" wrote in message
...
Don't believe it. Fathers often give their names to their sons (and
mothers
to daughters) so it is going to be more-than-averagely likely for the
same
name to be present at the same address.
Exactly. My father and my older brother were both named Robert Trapp and
lived at the same address until my brother went to college. Adding a
middle
initial to the mix would have distinguished them, but that wouldn't always
be the case. It happens all the time.
--
Lynn Trapp
MS Access MVP
www.ltcomputerdesigns.com
Access Security: www.ltcomputerdesigns.com/Security.htm