Splitting one field into multiple fields in a Report

[Canadiangal]

I have a field called Services that has a 10 different service options. I want to produce a report where it lists the patrons name and the service/services that they have received on one line.

I don't want to group by service. How can I split this field?
Thanks in advance for any help you can give.

[June7]

You say 'split' the field but sounds like you really want to concatenate values from multiple records. Review: http://allenbrowne.com/func-concat.html

[Canadiangal]

Your correct June. I have a table called services, with the fields Service and ServiceID.
I have another table called ServiceData, with the fields: ServiceID, Results, Date Administered, Date Due, and Assessment.
When I pull it into a report, then it would seem like my best case scenerio is to place the Service in a group header. However, the request is that the data resemble a table, with the persons name first, then all of the services following with the results, date administered, date due, and assessment.

[June7]

A grouping report is the simplest output for your data. In addition to the ConcatRelated function, review these links for other techniques to 'rotate' data.
http://forums.aspfree.com/microsoft-...ry-322123.html
http://datapigtechnologies.com/flashfiles/crosstab.html