Creating a New Record from Many Records

[TigersChristina]

I wasn't quite sure where to ask this so I'm posting this in the general area first.



I have a table of notes by matter number. Each matter number is unique and could have more than one note assigned to it so there could be 5 notes (5 records) for the same matter number.

Is there a way to create a new table that lists the matter number in one field and in the other field, ALL of the notes from the original table (all in one field, separated by commas, etc.).

It is almost like concatenating or adding together a bunch of fields (colunns) in ONE RECORD but what I want to do is add a bunch of records (rows) together to get one record that contains ALL of the notes in one field and the matter number in the other field.

I might also need to narrow it down to the date when the note was recorded.

If you have any ideas on how to do this, I would really appreciate your help.

Thanks so much!

[pbaldy]

This type of thing?

http://access.mvps.org/access/modules/mdl0004.htm