VB routine to concantonate MSA records

[Guest]

I have an MS Access 2003 table with 2 data fields.
Fld 1 ids records within common groups with repeated value in records
belonging to that group.
Fld 2 has sequentioal history information about unique groups.
I want to collapse the table 1 into a new table 2 with one record pe uniquie
group Id (Fld 1), sequentially concantonating history data from Fld 2 for
records with commone value for Fld 1, starting new record in the new table
when record from first table has new value for Fld 1
I need a short VB prgm to look up first table (sorted on fld 1), store info
for first record from Fld 1 to short term memeory, copy info from fld 2 of
first table to fld 2 of new table, then move to next record in first table,
compare value in fld 1 to value in memeory, if same, concantonate data in fld
2 from second record of table 1 to fld 2 of first record of table 2, then
repeat, if see new value in fld 1 of table 1 not equal to previosuly stored
value in memory, start new record in table 2 etc.
Can anyone provide me with a little VB routine to do that ?

 

[John Nurick]

See http://www.mvps.org/access/modules/mdl0008.htm