[dba-VB] Merge rows

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





More information about the dba-VB mailing list