Z
Zoomiest
I am trying export data from my old contact management database... For
the NOTES, it has many notes records (different dates) for each contact
person.
I would like to somehow run a query that would make it 1 record per
contact, writing the date, then the note for that date, all into one
record. (Yes, so the notes will be all in a blob, separated by
different dates.)
So, the new records would have essentially two fields: the contactID
and the Notes field, will all dates and notes in one field.
(This will allow me to import the notes files into a new database...)
How would I run such a query?
- Allan
Canada.
the NOTES, it has many notes records (different dates) for each contact
person.
I would like to somehow run a query that would make it 1 record per
contact, writing the date, then the note for that date, all into one
record. (Yes, so the notes will be all in a blob, separated by
different dates.)
So, the new records would have essentially two fields: the contactID
and the Notes field, will all dates and notes in one field.
(This will allow me to import the notes files into a new database...)
How would I run such a query?
- Allan
Canada.