Svein Erling Tysvær wrote:

> SELECT "Date"
> , sum(Case when "Time" = '9.00' then "Issued" else 0 end) as "9:00"
> , sum(Case when "Time" = '9.25' then "Issued" else 0 end) as "9:15"
> , sum(Case when "Time" = '9.50' then "Issued" else 0 end) as "9:30"
> FROM Z
> GROUP BY 1

AH ... now that makes sense ... and I can expand it to include waiting time
easily enough ... Cheers!

--
Lester Caine - G8HFL
-----------------------------
Contact - http://lsces.co.uk/wiki/?page=contact
L.S.Caine Electronic Services - http://lsces.co.uk
EnquirySolve - http://enquirysolve.com/
Model Engineers Digital Workshop - http://medw.co.uk//
Firebird - http://www.firebirdsql.org/index.php