return comma separated list


G

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
 
Ad

Advertisements

Ad

Advertisements

G

Guest

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top