[dba-VB] Merge rows

This is a tough question - not technically difficult but what's tough is
actually making the choice!  

I think you'll need to get some guidance from your customer as to which
single record to keep (the latest one?), or should you put the contents of
all the related cells into one cell and delete the other rows?  Or something
else?

This probably doesn't help . . .
Dan


-----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