return comma separated list

[Guest]

I need a way to return a comma-separated list.

Currenty I have a table that has a field with unique SAR_ID's and a field
with a comma-separated list of DBM numbers. For example:
SAR_ID DBM
--------- -----
1234 DBM_001, DBM_002
1235 DBM_002

Instead I want to have the following:
SAR_ID DBM
--------- -----
1234 DBM_001
1234 DBM_002
1235 DBM_002

Currently the user has a form, based on a query, that shows all the DBMs for
a SAR on one comma-separated line.

Can someone point me to an existing article or give me some pointers on how
to accomplish this when the values aren't already in one field?

Thank you,
Judy

 

[Allen Browne]

See:
Return a concatenated list of sub-record values
at:
http://www.mvps.org/access/modules/mdl0004.htm

 

[Guest]

Thank you for responding. I look forward to trying this when I return to
work on Monday!
Judy