Lonnie Johnson
prodevmg at yahoo.com
Thu Jun 23 10:53:27 CDT 2005
Question: What do you do if they actually have a middle name and two last names? Susan Harkins <ssharkins at bellsouth.net> wrote: I see your point -- but how do you handle those times when you're not gleaning middle names, just first and last -- for instance, a simple mailing list where you don't want to include middle names, but where the person "goes by" Sales Harkins... You'd leave off Sales -- which isn't a crisis, but could make some people mad. For me, Sales is just part of my writing name -- I don't use it officially -- don't' sign anything with it, but it's an identifier. Years ago, I learned that another Susan Harkins was the editor of another technical journal -- that was just too close for comfort -- I added the Sales. Now, if you sent me a letter addressed to Susan Harkins, I wouldn't care or get angry -- but some might. Is this worth considering? I suppose one answer is to simply always use the middle name in all cases, but that seems overkill. Susan H. I use middle name. My feeling is that no one cares if it's actually a last name or middle name. Either way it's in the right place all the time if you use a middle name field. The question really is how is that person listed on legal documents. If, for example, you are listed on your mortgage or social security (or whatever) as Last name = Sales Harkins, First name = Susan then that's the last name, but if you use it "unofficially" then I would make it a middle name. Reuben Cummings GFC, LLC phone: 812.523.1017 email: reuben at gfconsultants.com -----Original Message----- From: accessd-bounces at databaseadvisors.com [mailto:accessd-bounces at databaseadvisors.com]On Behalf Of Susan Harkins Sent: Thursday, June 23, 2005 9:46 AM To: 'Access Developers discussion and problem solving' Subject: RE: [AccessD] Normalizing issue So you both depend on the data entry person to enter Harkins Sales instead of Sales Harkins? That's interesting. ;) Susan H. The number of records that have a second last name vs those that don't dosen't warrant our efforts to program around it. We put the burden of keying it in properly on the business/clerical departments. -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com -- AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com May God bless you beyond your imagination! Lonnie Johnson ProDev, Professional Development of MS Access Databases Visit me at ==> http://www.prodev.us __________________________________________________ Do You Yahoo!? Tired of spam? Yahoo! Mail has the best spam protection around http://mail.yahoo.com