concatenate text field suggestions

[lisagippe]

Hi!

I have a table Name, Date, Hours, Comments. Each day an employee will have an entry Name, Date Hours, Comments (which might be blank).

I need a weekending report that shows Name, Total Hours (summed, and all the comments. This is where the problem lies. I have the hrs totaled but I can't get the comments from all the days to concatenate into one field. Is it possible to do this or am I delusional? Below example data

Name Date Hrs Comments
Sally 1/8/08 8
Sally 1/9/08 6 left early sick
Sally 1/10/08 4 1/2 day sick

So I need to see:

Name Ttl Hrs All Comments
Sally 18 left early sick, 1/2 day sick

Ideas? Thanks!!! Lisa

 

[lespaul]

see FAQ701-4233

Leslie

In an open world there's no need for windows and gates

http://www.ubuntu.com