Chris,

thanks for reply. I should have posted what the result set was that I'm after. There should be two rows for each person, one recording total count of tickets and the other total duration of tickets. It should look like this:

Name, Category, Value

Helen | Count | 2

Helen |Duration| 28

Joe | Count | 2

Joe |Duration| 33

Blake | Count | 2

Blake |Duration| 62.

If Helen had another ticket, then count would go up to 3 and Duration would increase.