Need to merge multiple records in to one.. Can it be done?

[Mark]

I have a table with thousands of records containing a clients name in one
field, a date in a second field and then a note in a third field. A new
record is created each time a note was entered for that client.

Example:

Client A 01/01/01 First Note
Client A 01/05/01 Second Note
Client A 02/10/01 Third Note
Client B 01/01/01 First Note

What I need to do is convert this information so each client only has one
record and in that record are all of their notes and the dates for those
notes. The data is going to be imported in a new program so it must be in
the new format. Can someone provide me with some guidence on how to do this
or is it not possible?

Thanks

Mark Warner

 

[Tom van Stiphout]

On Mon, 3 Dec 2007 13:34:02 -0800, Mark

Perhaps you can use this as a starting point:
http://www.mvps.org/access/modules/mdl0004.htm

-Tom.

 

[Pete D.]

First make a copy to work on. Second, make sure the original is in a safe
place and make sure it still works.

2. Check and make sure your clients were entered the same way in all the
records.

3. Make a table defenition for customer info with unique key no duplicates
for customer and update query from table for client info.

4. Run this query which will produce multi errors of duplicate keys. Ignore
and let run.

4. Make a update table query for date and note info with the client info
dulicates allowed.

5. next link tables with client unique info as client table primary and one
to many with memo table with client info linked to client table , as the
many table.

6. Pray to God I explained it right and test.

7. Problem solved or repost as what did you say?