Dan Waters
dwaters at usinternet.com
Mon Sep 21 14:10:09 CDT 2009
I'd stick with a single preference for a car or a drink, but for women you'll need a subtable. Hope this helps! Dan -----Original Message----- From: dba-vb-bounces at databaseadvisors.com [mailto:dba-vb-bounces at databaseadvisors.com] On Behalf Of Andy Lacey Sent: Monday, September 21, 2009 1:42 PM To: 'Discussion concerning Visual Basic and related programming issues.' Subject: Re: [dba-VB] Merge rows 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 _______________________________________________ dba-VB mailing list dba-VB at databaseadvisors.com http://databaseadvisors.com/mailman/listinfo/dba-vb http://www.databaseadvisors.com