Andy Lacey
andy at minstersystems.co.uk
Mon Sep 21 13:41:44 CDT 2009
Give up the drink and the cars Andy -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of jwcolby Sent: 21 September 2009 18:46 To: db >> VBA Subject: [dba-VB] Merge rows My database from hell has some records where the records grouped by the natural PK have duplicates, and the duplicates have different information out in the non-pk fields. IOW I have two or three or 5 records for John Colby where other fields out there have various information. The first record might have my preferences in cars, whereas the second might have my preferences in drink, whereas the third might have my preferences in women (JOKING!!!). I really need to do a merge / purge to merge these records into a single remaining record. Any suggestions where to start on such an idea? -- John W. Colby www.ColbyConsulting.com _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com