Group by, expression help

[offie]

I'm sure this is simple but I can't think at all of how to do it

2 Fields: ProjectCode and Source

I am grouping by the ProjectCode

Source can be CO or FO

I would like be able to display CO, FO, CO and FO

ex:
1 CO
1 CO
2 CO
2 CO


2 FO

Gives
1 CO
2 CO and FO

Thanks!

[pbaldy]

To get 2 lines, I think you're looking at something like this:

http://allenbrowne.com/func-concat.html