Colby, John
JColby at dispec.com
Tue Nov 16 12:59:14 CST 2004
You can but... the probability of dirty data is 100%. IOW, the probability that they mis-spelled things they were typing in over and over will make the process of normalization somewhat more painful than dentistry sans Novocain. If you still want to, say so and I will provide info on the "how to". John W. Colby The DIS Database Guy -----Original Message----- From: John Clark [mailto:John.Clark at niagaracounty.com] Sent: Tuesday, November 16, 2004 1:31 PM To: accessd at databaseadvisors.com Subject: [AccessD] duplicates question * can't find in archives I have been searching archives, but I can't find this yet... I am rewriting a DB that was originally done on a Unix box. I have imported their data and I am trying to make it fit my scheme. Their way (the old way) was to enter all information again and again and again. This DB is tracking residents going to school out of district (I guess there is some reimbursement from home county) and each semester they enter SSN, Name, School, etc.. I am making the student screen so that once the SSN, Name, & Address is entered, the rest is entered in a subform. So I think I need to take the current table and break it down into two tables. I will have to rid the student table of all dups and somehow link the other table...the new tbl_stntdata table...to the tblStudent table. How do I get rid of all the dups? Or can I? Maybe I'll just tell them that they'll have to go "day forward." -- _______________________________________________ AccessD mailing list AccessD at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/accessd Website: http://www.databaseadvisors.com