Summarizing selected values from a check list

[amemme]

Hi,

I am trying to summarize selected items from a value list that uses check boxes. I need to summarize on the selected items in a field that shows the data left to right separated by comma's and not paragraph returns. See example below.

From a list of countries that the following countries are selected:

China, Canada, Australia.

Field currently shows it as the following:

China

Canada

Australia

What I'm looking for is:

China, Canada, Australia

The reason for this I can add it to a form that shows all of the relating countries in a single field.

Any info on this will be greatly apprecieated!

Thanks,

Anthony

[Vaughan]

Create a calculation field to display the selected values:

Substitute(field, "

[amemme]

Vaughan,

Thanks very much, this is much easier than the way I came up with.

Thanks,

Anthony