quote:

---

Originally posted by Isabel


I have a question about formatting a query output to be displayed properly

Here is some backgroud info:
Tools:
SQL reporting Designer

Tables:
1.Activity
2.Attendees (activityid is foreign key in this table)
I have the query in place , but having problems diplaying it neatly:

query:

select activityname,attendees from activity,attendees
where attendes.activityid = activity.activityid

I am trying to diplay attendees for all the actiivties example:
Appointment1: John,Smith,Steve
Appointment2: Ray,Bob
and so on....
How do generate this report so that all the attendees for a given activity are in one row (not a row for each attendee)

any help will be appericated.
Thanks.

---