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