[dba-VB] Merge rows

ROTFL.  A darned fine idea.

Not the things my wife would have me give up.

;)

KIDDING!

John W. Colby
www.ColbyConsulting.com


Andy Lacey wrote:
> 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?
>