Combine counted values from one column into one row

I have a query where I can have a count(*) counting certain values of progress and outputting like this:

Mike Approved 3
Mike Not Started 5
John Approved 2
John On Hold 5

Does anyone know how I can display as:

           Approved     Not Started    On Hold
Mike    3                      5                   0
John    2                      0                   5

Have been trying things crazily all day, please help! (Or point me in the correct direction if possible) Thanks in advance

KA Received on Thu May 17 2007 - 17:54:12 CDT