Condensing data from one field for one record

[Sandie]

I have report that needs to list a schedule of sorts in the following way

Name
TaskID 1 Task Desc Mon, Wed, Fri
TaskID 2 Task Desc Tues, Thurs, Fri

My tables looks something like this:

Table: Tasks
TaskID
Task Name
Task Desc

Table: TaskDayAssignments
TaskID
TaskDayAssignment


So, a Task can have several different days of the week assigned to it (i.e.
several child recs in the TaskDayAssignment table) But since there can only
be a max of 7 days given to any Task, and I need to make as condensed a
report as possible, I'd like to be able to list the days across the report
instead of in rows. Is there a way to concatenate them or something? I think
a crosstab query might work but I'm not sure how to go about making it work.

As it is now, the report looks like this:

Name
TaskID 1 TaskDesc
Mon
Wed
Fri
TaskID 2 Task Desc
Tues
Thurs
Fri

As you can see, if I were able to string the days into one line, I'd save
alot of space on the page which is what I really need.

Any help is greatly appreciated!

 

[Sandie]

Nevermind! I think I found something that will do exactly what I need.

In case anyone else needs to "concatenate child records" (the phrase I
SHOULD have searched for initially ) here is a link:

http://www.rogersaccesslibrary.com/...Generic Function To Concatenate Child Records'

I haven't tried it yet, but I think it's going to do exactly what I need.

 

[Duane Hookom]

The function should work. Come on back if you have a question of how to
implement it.