Need conceptual ideas on how to query design

[padlocked17]

All,

I have a block on a report that I want to essentially contain some conditional formatting (will probably require VBA, but would like to keep it to a minimum).

The stumbling block is how to go about generating the query and the content of this block.

This database essentially tracks tasks that each person does and each task belongs to a category (SectionName). I want this one block to contain a text string of each category that an event is overdue for and then I want to use conditional formatting to assign a color to this block.

You can see from the "sample tables" below, I want to select all records that have a Due_Date_Flag equal to *** and display the section name. Up to this point, no problem. If there are multiple records that equal ***, I want to concatenate the SectionName's to look like "Flight, Mobility". I then wanted to use the SectionSeverity to dictate the conditional formatting for the box on the report. IE, if there are multiple tasks, it would use the task with the greatest SectionSeverity for the conditional formatting.

My 3 tables that I'm working with are basically:

Current_Events:
SSN | Task_ID | Due_Date_Flag
1 | 1 | ***

Tasks:
Task_ID | SectionID
1 | 2

TaskSections:
SectionID | SectionName | SectionSeverity
1 | Flight | 4
2 | Mobility | 3


I tried to explain the best I could, and any guidance would be greatly appreciated. I'm really looking for more of some ideas on how to tackle this.

Thanks.