Hi all..I don't know if this is possible or not..but any help would be so appreciated.

This is a scaled down version of my problem..

Two tables..

Person
id number
name

Activity
id number
activity

A person can have multiple activities.

Instead of the report printing a row for each activity like this..
id number, name, activity 1
id, number, name, activity 2

I would like it to print like this..
id number, name, activity 1, activity 2, activity 3...ect..

The number of activities a person can have varies..

Does anyone have any idea is this is possible and how to do it?

Thanks.
Veronica